topic Re: Remove if the variable doesn't have duplicate in SAS Programming

Remove if the variable doesn't have duplicate

user24 — Thu, 02 Mar 2017 13:46:42 GMT

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.

Re: Remove if the variable doesn't have duplicate

art297 — Thu, 02 Mar 2017 13:58:55 GMT

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

Re: Remove if the variable doesn't have duplicate

LinusH — Thu, 02 Mar 2017 14:51:15 GMT

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

Re: Remove if the variable doesn't have duplicate

Ksharp — Fri, 03 Mar 2017 04:05:18 GMT

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;