Common variable in a library

[BrahmanandaRao]

title ' How to find Common variables in a Library';

data ds;
set sashelp.class;
run;

data ds1;
set sashelp.class;
run;



proc sql;
select * from dictionary.columns 
where libname='WORK'
and memname in ('DS', 'DS1')
group by upcase(Sex)
having count(*)>1;
quit;

 ERROR: The following columns were not found in the contributing tables: Sex.


[Kurt_Bremser]

And what is the question?

[ballardw]

Dictionary.columns has no variable named SEX.

maybe you wanted

"and upcase(name)='SEX' "

on the where statement and then

group by Upcase(name)

or maybe completely ignoring the "memname in " part of the where if you are looking for the number of data sets that have "SEX" as a variable.