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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.