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