Proc sort nodupkey is not working

[abhityagi]

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

[Kurt_Bremser]

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