Does DICTIONARY.COLUMNS even work for a libref using HADOOP engine?   Do you want to compare the DEFINED length of the variables?  Or the maximum length of the actual values stored in the variable?   To just check the defined length you can use the metadata.  You should also check if the variables are defined with consistent types (numeric or character). proc sql ; create table length_report as select upcase(name) as NAME , count(*) as n_datasets , max(length) as max_length , min(length) as min_length , count(distinct length) as n_lengths , min(type) as min_type , max(type) as max_type , count(distinct type) as n_types from dictionary.columns where libref='HADOOP' group by 1 order by 1 ; To actually find the maximum observed length you will need to generate queries against each of the datasets. ... View more

So I interpret the question as: You've got some data in a CAS lib that you can see in SAS Viya. You now want to use SAS Studio ("Develop SAS Code") to access the data in that CAS Library.   That's quite easy: You need to use a libname statement using the CAS engine like this:   * here, abc is the libref, cas is the CAS engine and you specify the library name (exactly as defined in CAS) in caslib=; Libname abc cas caslib='XYZ';   *the following will list the tables that are in the CAS library proc datasets lib=abc; quit; *assuming you have a table called sales in the caslib, then you can use it in code like this: data MaySales;  set abc.sales;  where Month='May'; run;   I've made some assumptions with the above code, particularly the libname statement. I assume that you are using SAS StudioV that is in the same environment as SAS Viya. That way you don't have to specify CAS connection information. If you are using SASStudio or other SAS Coding tools like Enterprise Guide that are separate from the SAS Viya environment then you will have to specify the cashost, port and maybe authentication.   HTH   Mark       ... View more