Code plz

Reply
Frequent Contributor
Posts: 86

Code plz

Hi,

I have some 50 library's each library has 200 tables...

Now i want know all the library names, all the tables names, all the column names, type, length, label name,...how to get is there any code plz share it.

Thanks,

Suresh

Respected Advisor
Posts: 3,124

Re: Code plz

Hi,

There are metadata tables/views available for this purpose:

proc sql;

select libname, memname,name, type, label,length from dictionary.columns

where libname not in ('SASHELP' 'SASUSER' 'MAPS');

quit;

Here is a cheat sheet:

http://www.codecraftersinc.com/pdf/DictionaryTablesRefCard.pdf

Updated to remove SAS utility libraries.

Regards,

Haikuo

Ask a Question
Discussion stats
  • 1 reply
  • 163 views
  • 0 likes
  • 2 in conversation