3264   %dupcheck(records, id);

NOTE: No output data set specified.
      Defaulting to records_dup and/or records_one.

NOTE: Number of by variables specified: 1

MPRINT(DUPCHECK):   proc sql;
MPRINT(DUPCHECK):   quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


MPRINT(DUPCHECK):   proc sql;
MPRINT(DUPCHECK):   create table _bycount_ as select id, sum(1) as Count from records group by id
order by id ;
NOTE: Table WORK._BYCOUNT_ created, with 8 rows and 2 columns.

MPRINT(DUPCHECK):   quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


MPRINT(DUPCHECK):   data _dup_ _one_;
MPRINT(DUPCHECK):   set _bycount_;
MPRINT(DUPCHECK):   if count>1 then output _dup_;
MPRINT(DUPCHECK):   else output _one_;
MPRINT(DUPCHECK):   run;

NOTE: There were 8 observations read from the data set WORK._BYCOUNT_.
NOTE: The data set WORK._DUP_ has 1 observations and 2 variables.
NOTE: The data set WORK._ONE_ has 7 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


MPRINT(DUPCHECK):   option nomprint;

WARNING: Duplicates found in RECORDS by ID!