07-03-2012 05:54 PM
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.
07-03-2012 06:13 PM
There are metadata tables/views available for this purpose:
select libname, memname,name, type, label,length from dictionary.columns
where libname not in ('SASHELP' 'SASUSER' 'MAPS');
Here is a cheat sheet:
Updated to remove SAS utility libraries.