Comparing 3 datasets

[sfridy]

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!

[ballardw · Accepted solution]

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.

[sfridy]

It's part of a data profiling effort. I'm trying to get an understanding of the discrepancies between the datasets.

[sfridy]

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!