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
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.
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;
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
tq for help
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.