Hi All,
I am trying to export all the variable name, their trype(char, num, data), along with their dataset name to a Excel sheet.
Tried the following code(thanks to SASKIWI) , but got only the list of variables name and respective dataset thary belong, i need the variable type as well.
Please suggest
/* Note that value of libname is UPPERCASE */
proc sql;
create table columns as
select name as variable
,memname as table_name
from dictionary.columns
where libname = 'WORK'
;
quit;
/* SAS 9.4 or later */
ods excel file="C:\e_Contents.xlsx" style=minimal;
proc print data=columns;
run;
ods excel close;
/* earlier versions, using SAS/ACCESS to PC Files */
PROC EXPORT data = columns
OUTFILE = 'e_Contents.xls'
DBMS = EXCEL REPLACE;
SHEET='VARLIST';
RUN;
thanks Guys,
Got it....
the following code works
Proc contents data=work._ALL_;
run;
If you use this code you can find out how to request other items from dictionary.columns
proc sql; describe table dictionary.columns; run;
which would lead to
proc sql; create table columns as select name as variable ,memname as table_name,type from dictionary.columns where libname = 'WORK' ; quit;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.