Hi,
I am a new user and I need to specify my company's data base by listing all variables in each set in the library and provide a sample of the data existed in each variable (the best sample to provide is the most frequent one ) . Library A
Sets :
- X has 1 , 2, 3
- Y has 1 , 4 , 5
and Z has 2 , 9 , 8
I used this code so far , but I couldn't find out how to provide samples (using SQL) :
*List of variables in a library;
proc sql;
create table columns as
select libname ,
memname as table_name ,
name as variable
from dictionary.columns
where libname = 'A'
;
quit;
Could you please help me with that ? Thanks and have a nice day. KR // Alaa
... View more