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.
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;
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;
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?
Actually,
It was my mistake....it works. Thank you much!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.