Proc sort nodupkey is not working

abhityagi — Fri, 13 Dec 2019 18:49:28 GMT

Hi Guys,

I am trying to get duplicate records based on the nodupkey which find the duplicate records based on the by statement. However, It is giving me no-duplicate records in duplicate output file(dup_recs). Given is the syntax I have used.

proc sort data=table1 nodupkey out=without_dup dupout=dup_recs;
by &col.;
run;

and col macro keep the 178 column to validate if there is any duplicate record or not.

Thanks,

Abhishek

Re: Proc sort nodupkey is not working

Kurt_Bremser — Fri, 13 Dec 2019 19:01:00 GMT

If you have 178 columns in the by statement, all 178 have to be identical between observations to constitute a dupiicate.

topic Proc sort nodupkey is not working in SAS Programming

Proc sort nodupkey is not working

Re: Proc sort nodupkey is not working