topic Re: table and column names in common in SAS Data Management

table and column names in common

Tecla1 — Wed, 12 Dec 2018 15:51:06 GMT

Good afternoon,

I have a library with more tables i need to create a new table who contains all the names of columns (of all tables) and in wich table the column name is contained.

Can you suggest something?

Tnks!!!!

Tecla

Re: table and column names in common

PaigeMiller — Wed, 12 Dec 2018 15:52:46 GMT

The work is already done for you. Use the DICTIONARY table.

proc sql;
    create table want as select * from dictionary.columns;
quit;

Re: table and column names in common

ballardw — Wed, 12 Dec 2018 16:14:11 GMT

proc sql;
    create table want as select * from dictionary.columns
       where libname='YOURLIB'
   ;
quit;

The libname (as well as memname for datasets) is stored in the dictionary view in all upper case so either provide the name in upper case or use other method to ensure your name value and the libname is the same case for comparison

Re: table and column names in common

Jagadishkatam — Wed, 12 Dec 2018 16:17:03 GMT

Alternatively with a dataset

data want;
set sashelp.vcolumn;
where libname='WORK';
run;