topic Re: SAS Libraries in SAS Programming

SAS Libraries

santhoshlekkala — Sun, 14 May 2017 11:47:36 GMT

hello everyone,

few days back i have attended an interview, the interviewer asked a question:-

consider a case, there are 50 libraries, each libraries has some sas datasets. so i want to list only those sasdatas which has a column or variable X in all the sas datasets from all the libraries?????

plzz help me

Re: SAS Libraries

Jagadishkatam — Sun, 14 May 2017 13:08:31 GMT

Ok in this case, sashelp.vcolumns will help us. in this we could check all the libraries, datasets and the variables they have.

in your case check like this

data want;

set sashelp.vcolumns;

where name='X';

run;

This will subset on the list of libraries(libname) and datasets (memname) that have variable with name X.

Re: SAS Libraries

Jagadishkatam — Sun, 14 May 2017 13:42:04 GMT

Alternatively by proc sql also we could achieve the same result

proc sql;
create table want as select libname, memname , name from dictionary.columns where name='X';
quit;

Re: SAS Libraries

Reeza — Sun, 14 May 2017 13:34:35 GMT

They wanted to know if you're familiar with Dictionary tables.

You can find details in many papers on LEXJANSEN.COM

Common usages:

Create data dictionary

Automate creation of labels or rename variables

Re: SAS Libraries

santhoshlekkala — Mon, 15 May 2017 17:37:55 GMT

tq for help