topic Common variable in a library in SAS Programming

Common variable in a library

BrahmanandaRao — Tue, 06 Apr 2021 06:52:27 GMT

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.

Re: Common variable in a library

Kurt_Bremser — Tue, 06 Apr 2021 06:49:41 GMT

And what is the question?

Re: Common variable in a library

ballardw — Tue, 06 Apr 2021 07:05:38 GMT

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.