Desktop productivity for business analysts and programmers

How is it possible to find from a library a dataset that contains two or more variable

Reply
Regular Contributor
Posts: 168

How is it possible to find from a library a dataset that contains two or more variable

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,

Super User
Super User
Posts: 9,840

Re: How is it possible to find from a library a dataset that contains two or more variable

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;
Ask a Question
Discussion stats
  • 1 reply
  • 84 views
  • 0 likes
  • 2 in conversation