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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.