Comparing two columns

[DubsNU]

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.

[RW9 · Accepted solution]

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;

[DubsNU]

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?

[DubsNU]

Actually,

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