Hello,
I have used many times the following code to find in which dataset in a particular library, a variable exist?
proc sql;
select name,memname
from dictionary.columns
where libname EQ 'MYLIBRARY' and UPCASE(name) EQ 'CUSTOMERNUMBER' ;
quit;
run;
How is it possible to find a dataset that contains two variables or more?
For exemple, if I am interested by var1 and var2, I would like to find a dataset Which have those two variables.
Any suggestion?
Regards,
Exactly the same, you just alter the where to fit your needs:
proc sql; select name,memname from dictionary.columns this where exists(select name from dictionary.columns where libname=this.libname and memname=this.memname and name="VAR1") and exists(select name from dictionary.columns where libname=this.libname and memname=this.memname and name="VAR1"); quit;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.