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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: