topic Re: Checking if two datasets are identical in SAS Programming

Checking if two datasets are identical

jackmelbourne — Fri, 31 Mar 2017 12:52:08 GMT

Dear All,

I was wondering if there was any way to check if two datasets are the same? For example, I want to check if set 1 and set2 are identical. In this case they wouldn't be. Also, it's for a much bigger dataset if that makes any difference.

data set1;
   input Name :$upcase4. Age Net Reg Loss;
   cards;home 300 200 50     .
home 100 80   .     5
TDR  80  75   .     3
TDR  70   .   5     .;;;;
   run;

data set2;
   input Name :$upcase4. Age Net Reg Loss;
   cards;home 300 200 50     .
home 100 80   .     6
TDR  80  75   .     3
TDR  70   .   5     .;;;;
   run;

Thank you very much in advance!

Kind regards,

Jack

Re: Checking if two datasets are identical

collinelliot — Fri, 31 Mar 2017 12:59:00 GMT

PROC COMPARE should do what you want.

data set1;
   input Name :$upcase4. Age Net Reg Loss;
   cards;
home 300 200 50     .
home 100 80   .     5
TDR  80  75   .     3
TDR  70   .   5     .
;;;;

data set2;
   input Name :$upcase4. Age Net Reg Loss;
   cards;
home 300 200 50     .
home 100 80   .     6
TDR  80  75   .     3
TDR  70   .   5     .
;;;;
  
proc compare data = set1 compare = set2;
run;

Re: Checking if two datasets are identical

collinelliot — Fri, 31 Mar 2017 12:59:41 GMT

Note that it can be used with by groups as well.