topic delete duplicate records in SAS Programming

delete duplicate records

kishore415 — Fri, 23 Sep 2011 04:19:46 GMT

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

2 bbb yyy

3 ccc zzz

4 ddd zzz

result should be

id name dept

2 bbb yyy

4 ddd zzz

Thanks in advance....

delete duplicate records

Ksharp — Fri, 23 Sep 2011 08:21:42 GMT

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