DATA Step, Macro, Functions and more

delete duplicate records

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

delete duplicate records

HI..

    I have a sitation where I need to delete all duplicated records without keep one unique row.Can anyone help me to achieve this .

For example...

  id name dept

  1 aaa    xxx

  1 aaa    xxx

  2 bbb    yyy

  3 ccc    zzz

  3 ccc    zzz

  4 ddd    zzz

result should be

 

   id name dept

   2  bbb    yyy

   4  ddd    zzz

Thanks in advance....


Accepted Solutions
Solution
‎09-23-2011 04:21 AM
Super User
Posts: 10,046

delete duplicate records

Posted in reply to kishore415

How about:

data temp;
input id name $ dept $;
cards;
  1 aaa    xxx
  1 aaa    xxx
  2 bbb    yyy
  3 ccc    zzz
  3 ccc    zzz
  4 ddd    zzz
;
run;
proc sql noprint;
 create table want as
  select *
   from temp
    group by id,name,dept
     having count(*) eq 1;
quit;
















data temp;
input id name $ dept $;
cards;
  1 aaa    xxx
  1 aaa    xxx
  2 bbb    yyy
  3 ccc    zzz
  3 ccc    zzz
  4 ddd    zzz
;
run;
proc sort data=temp;by id name dept;run;
data want;
 set temp;
 by id name dept;
 if first.dept and last.dept;
run;


Ksharp

View solution in original post


All Replies
Solution
‎09-23-2011 04:21 AM
Super User
Posts: 10,046

delete duplicate records

Posted in reply to kishore415

How about:

data temp;
input id name $ dept $;
cards;
  1 aaa    xxx
  1 aaa    xxx
  2 bbb    yyy
  3 ccc    zzz
  3 ccc    zzz
  4 ddd    zzz
;
run;
proc sql noprint;
 create table want as
  select *
   from temp
    group by id,name,dept
     having count(*) eq 1;
quit;
















data temp;
input id name $ dept $;
cards;
  1 aaa    xxx
  1 aaa    xxx
  2 bbb    yyy
  3 ccc    zzz
  3 ccc    zzz
  4 ddd    zzz
;
run;
proc sort data=temp;by id name dept;run;
data want;
 set temp;
 by id name dept;
 if first.dept and last.dept;
run;


Ksharp

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 144 views
  • 1 like
  • 2 in conversation