topic Re: How is it possible to find from a library a dataset that contains two or more variable in SAS Enterprise Guide

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

alepage — Wed, 09 May 2018 13:29:39 GMT

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,

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

RW9 — Wed, 09 May 2018 13:41:51 GMT

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;