Find variable names that are in one dataset but not in another

eagles_dare13 — Mon, 05 Jan 2015 17:09:56 GMT

If I have 2 data sets:

data investment;

begin='01JAN1990'd;

end='31DEC2009'd;

run;

data investment_2;

begin='01JAN1990'd;

run;

I wish to write a program that will give me list of all columns that are in investment but not in investment_2. So in this case, the variable 'end'.

How to do this? I dont want to list out the column names using proc contents on eaqch dataset and then manually eyeball it and check for differences.

Re: Find variable names that are in one dataset but not in another

data_null__ — Mon, 05 Jan 2015 17:18:40 GMT

proc compare base=investment(obs=0) compare=investment_2(obs=0) listbase; 
   run;