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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.