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 ... View more

Hello everyone,   I have two datasets and I need to see if observations from one dataset are missing from another dataset. For example,   data have; input Name :$upcase4. id Net Reg Loss; cards;home 344 200 50 . home 543 80 . 5 TDR 453 75 . 3 TDR 543 . 5 . ;;;; run; data have; input Name :$upcase4. id Net Reg Loss; cards; home 344 200 50 . home 543 80 . 5 ;;;; run;  I want to see if any ids are missing in the second dataset compared with the first dataset. For example, id 453 is missing but 543 and 344 are not.   Thanks in advance 🙂   Kind regards, Jack ... View more