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.
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.