topic Re: Compare code in SAS Programming

Compare code

Aayushi_17 — Tue, 15 Mar 2022 07:24:35 GMT

How to compare to Two datasets and output the difference by using subject variable which is present in both domains using proc freq .

Dataset A;

subject

123

232

234

120

001

DATASET B

subject

123

232

234

Re: Compare code

Kurt_Bremser — Tue, 15 Mar 2022 07:49:39 GMT

If you just need to detect missing keys:

proc sort data=a;
by subject;
run;

proc sort data=b;
by subject;
run;

data
  both
  only_a
  only_b
;
merge
  a (in=in_a)
  b (in=in_b)
;
by subject;
if in_a and in_b
then output both;
else if in_a
then output only_a;
else output only_b;
run;

If you need more than that, look at PROC COMPARE.

Re: Compare code

ballardw — Tue, 15 Mar 2022 14:51:47 GMT

Why are you specifically stating the Proc Freq must be used? Proc freq takes a single data set as input.

Proc Compare is designed to compare data sets and can use BY processing to compare records based on values of common variables.

Your requirement of "output the difference by using subject variable" is not particularly clear as to the expected result.