topic Re: Comparing two columns in SAS Programming

Comparing two columns

DubsNU — Mon, 24 Feb 2014 15:54:20 GMT

Ok this is probably pretty simple for a lot of you.

I have two datasets....one called Stuff and the other called Stuff2.

They both have a column called Site with 95% of the same data in it. However Stuff2 has about 200 fewer records than Stuff. I would like to see which records are in Stuff and not in Stuff2 using Site as the key. Is there an easy way to do this? Thanks in advance.

Re: Comparing two columns

RW9 — Mon, 24 Feb 2014 16:08:57 GMT

Datastep:

Sort stuff by Site

Sort stuff2 by Site

data miss_stuff miss_stuff2;

merge stuff (in=a) stuff2 (in=b);

if a and not b then output miss_stuff2;

if b and not a then output miss_stuff;

run;

Re: Comparing two columns

DubsNU — Mon, 24 Feb 2014 16:55:09 GMT

Hmmm...doesn't seem to be working....the data set I'd expect to have the missing values from Stuff2 has 0 observations. Any ideas?

Re: Comparing two columns

DubsNU — Mon, 24 Feb 2014 16:57:02 GMT

Actually,

It was my mistake....it works. Thank you much!