Hi Team,
I found a code to get only duplicates using proc sort.
But I need to get the duplicates with more variables ..example var1, var2, var3, var4 ..
Somebody how to do it??
Thanks,
proc sort
data = test;
by var1;
run;
data single dup;
set test;
by var1;
if first.var1 and last.var1
then output single;
else output dup;
run;
proc sort data = test out=want nouniquekey ; by var1 var2 var3 var4; run;
You need to define what you mean by duplicate? Preferably provide some example data and an indication of which you consider duplicates.
A small variation on your program ought to do the trick:
proc sort
data = test;
by var1 var2 var3 var4;
run;
data single dup;
set test;
by var1 var2 var3 var4;
if first.var4 and last.var4
then output single;
else output dup;
run;
If this doesn't do it, you might need to answer some of the questions already asked, like the meaning of a duplicate.
proc sort data = test out=want nouniquekey ; by var1 var2 var3 var4; run;
Thanks for your solution
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.