topic Re: Variable name and Variable type in a library in SAS Programming

Variable name and Variable type in a library

SAS_INFO — Thu, 02 Mar 2017 02:49:24 GMT

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;

Re: Variable name and Variable type in a library

SAS_INFO — Thu, 02 Mar 2017 02:56:18 GMT

thanks Guys,

Got it....

the following code works

Proc contents data=work._ALL_;

run;

Re: Variable name and Variable type in a library

ballardw — Thu, 02 Mar 2017 16:25:34 GMT

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;