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!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: