topic Re: Proc Compare 4 to 5 datasets in SAS Programming

Proc Compare 4 to 5 datasets

Shyamkumar — Mon, 28 Sep 2020 09:21:15 GMT

Hi,

I have 4 datasets ,I need to proc compare between those. Please help me out with the examples.

Thankyou.

Re: Proc Compare 4 to 5 datasets

Kurt_Bremser — Mon, 28 Sep 2020 09:34:27 GMT

Since PROC COMPARE can only compare two datasets in one run, you have to do multiple runs.

The wizard in Enterprise Guide is good in assisting to create the code.

Re: Proc Compare 4 to 5 datasets

ballardw — Mon, 28 Sep 2020 21:24:45 GMT

It might help to tell us what exactly you want to know after the comparison(s) are complete.

If all you need to know is properties or existence of variables then you don't need Proc Compare.

If you need to compare individual values then are you looking for all or some of them? And how many variables would be involved.

Since proc compare only will compare 2 data sets at a time you are looking at the output of 10 "comparisons" which could be quite lengthy to browse through if there are specific questions you want answers about the datasets.