i have some variable names but how to find those variables in which dataset ?
Query system table dictionary.columns
proc sql;
select name, memname
from dictionary.columns
where libname="WORK";
quit;
I agree with @PGStats but wanted to point out that you don't have to specify libname when querrying dictionary.columns. e.g.:
proc sql; create table want as select name, libname, memname from dictionary.columns where upcase(name) in ('SEX','AGE') ; quit;
Art, CEO, AnalystFinder.com
Where do you get the variable names from that doesn't include what data they belong to? I mean you may find them per @PGStats solution, if you have setup libnames to them and they are datasets, however if you don't know your data, then those variables might point to CSV files, or databases or anything.
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.
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.