topic Keeping only duplicates with proc sort with more than one variable in SAS Programming

Keeping only duplicates with proc sort with more than one variable

Jcorti — Mon, 27 Mar 2017 15:12:01 GMT

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;

Re: Keeping only duplicates with proc sort with more than one variable

ballardw — Mon, 27 Mar 2017 15:40:12 GMT

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

Re: Keeping only duplicates with proc sort with more than one variable

Astounding — Mon, 27 Mar 2017 15:46:29 GMT

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.

Re: Keeping only duplicates with proc sort with more than one variable

Ksharp — Tue, 28 Mar 2017 04:08:39 GMT

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

Re: Keeping only duplicates with proc sort with more than one variable

Jcorti — Tue, 28 Mar 2017 16:31:22 GMT

Thanks for your solution