Remove if the variable doesn't have duplicate

[user24]

i want to remove if the id has not duplicate, like as below. Thisis table example i have now

id          desc                        i

15        W100786                 1

15        03/21/1970              2

20        K64478                   1

20        02/14/1968              2

21         M157842                1

22        W250143                1

22        02/15/2000              2

i need the table as below:

id          desc                        i

15        W100786                 1

15        03/21/1970               2

20        K64478                   1

20        02/14/1968               2

22        W250143                1

22        02/15/2000               2

So i need to remove the id:21, because it doesn't have duplicate.

[art297]

If you're data is already sorted by ID then a small data step would work:

data want;
  set have;
  by ID;
  if not(first.id and last.id);
run;

Art, CEO, AnalystFinder.com

[LinusH]

Or, if your data isn't sorted, try SQL GROUP BY, with a HAVING count(*) =2.

[Ksharp]

Or NOUNIQUEKEY.

data have;
input id          desc  : $20.                       i;
cards;
15        W100786                 1
15        03/21/1970              2
20        K64478                   1
20        02/14/1968              2
21         M157842                1
22        W250143                1
22        02/15/2000              2
;
run;


proc sort data=have out=want nouniquekey;
by id;
run;