DATA Step, Macro, Functions and more

Variable name and Variable type in a library

Reply
Contributor
Posts: 63

Variable name and Variable type in a library

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;

Contributor
Posts: 63

Re: Variable name and Variable type in a library

Posted in reply to arunasaran

thanks Guys,

Got it....

 

the following code works

 

Proc contents data=work._ALL_;

run;

Super User
Posts: 11,343

Re: Variable name and Variable type in a library

Posted in reply to arunasaran

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;
Ask a Question
Discussion stats
  • 2 replies
  • 135 views
  • 0 likes
  • 2 in conversation