Hello!
I'm looking to compare observations with the same id from three datasets. I've been using:
proc compare base=ctavcm compare=ctavtrax out=cmvstraxcomp outstats=cmvstraxcompstat outbase outcomp outnoequal listobs transpose;
by order;
var appt rel_rsn order_sts close_rsn;
format appt mmddyy10.;
run;
To compare two of them. And have follow up code to essentially compare pairings of the datasets. D1 to D2, D2 to D3 and D3 to D1, but am looking for a more efficient way to do this if one exists.
Thanks!
Are you looking for something in specific? It may be that combining the data sets and getting the source name as variable will allow calculations or summaries that at least put all 3 sets in a specific order. This would be more useful if there is a pretty much one-to-one relationship between the sets.
Are you looking for something in specific? It may be that combining the data sets and getting the source name as variable will allow calculations or summaries that at least put all 3 sets in a specific order. This would be more useful if there is a pretty much one-to-one relationship between the sets.
It's part of a data profiling effort. I'm trying to get an understanding of the discrepancies between the datasets.
Combining the three datasets was the perfect solution! Once combined I was able to create subsets with uncommon ids as well as perform a comparison between the IDs that existed in all three locations. Thank you!
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!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.