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

[alepage]

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,

[RW9]

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;