How to delete some rows within a group in SAS

Question

I want to identify any duplicates between rows of different groups and delete some observation.

My example :

data temp;
input siren $ imput $;
cards;
x one
x one
x two
y two
y two
z three
z three
z four
;
run;

The output I want :

siren imput
x one
x one
y two
y two
z three
z three

Many thanks in advance !

question from:https://stackoverflow.com/questions/65848148/how-to-delete-some-rows-within-a-group-in-sas

Answer 1

You can use PROC SORT for that.

data temp;
input siren $ imput $;
cards;
x one
x one
x two
y two
y two
z three
z three
z four
;
proc print;
   run;
proc sort data=temp out=dups nouniquekey;
   by siren imput;
   run;
proc print;
   run;