Code OUT= but not OUTBASE, OUTCOMP, or OUTDIFF. The basic stats produced by a Compare will give you the record count for the first dataset (well, both, but you asked about the first).
Sample code, below. Results below that. This code is borrowed from a macro I wrote for something else; you don't need to use a macro, but it's helpful if you have multiple datasets to compare. The results will be in WORK.Set_1c
%LET Old_Lib = WORK;
%LET New_Lib = WORK;
%LET Old_Data = Set_1;
%LET New_Data = Set_2;
%LET ID = ID;
**------------------------------------------------------------------------------**;
&Null %MACRO Compare_Datasets(Old_Lib, Old_Data, New_Lib, New_Data, ID=);
PROC SORT DATA = &Old_Lib..&Old_Data
OUT = WORK.&Old_Data.o;
BY &ID;
RUN;
PROC SORT DATA = &New_Lib..&New_Data
OUT = WORK.&New_Data.n;
BY &ID;
RUN;
PROC COMPARE BASE = WORK.&Old_Data.o
COMPARE = WORK.&New_Data.n
OUT = WORK.&Old_Data.c (DROP=_TYPE_ _OBS_)
NOVALUES LISTVAR
;
ID &ID;
RUN;
%MEND Compare_Datasets;
%Compare_Datasets(&Old_Lib, &Old_Data, &New_Lib, &New_Data, ID=&ID);
Results:
Jim
... View more
