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
If you have 178 columns in the by statement, all 178 have to be identical between observations to constitute a dupiicate.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.