Keeping only duplicates with proc sort with more than one variable

[Jcorti]

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;

[ballardw]

You need to define what you mean by duplicate? Preferably provide some example data and an indication of which you consider duplicates.

[Astounding]

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.

[Ksharp · Accepted solution]

proc sort
     data = test  out=want  nouniquekey  ;
     by var1 var2 var3 var4;
run;

[Jcorti]

Thanks for your solution