Find data sets with specific variables

Reply
Occasional Contributor
Posts: 5

Find data sets with specific variables

[ Edited ]

i have some variable names but how to find those variables in which dataset ?

Esteemed Advisor
Posts: 5,124

Re: i hava small doubt

Query system table dictionary.columns

 

proc sql;
select name, memname
from dictionary.columns
where libname="WORK";
quit;
PG
PROC Star
Posts: 7,791

Re: i hava small doubt

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

 

Super User
Super User
Posts: 8,634

Re: i hava small doubt

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.  

Ask a Question
Discussion stats
  • 3 replies
  • 193 views
  • 3 likes
  • 4 in conversation