|
Try :
proc sort data=yourdataset name nodupkey; by id; run;
data a;
input id $;
cards;
1
2
3
3
3
;
run;
proc print; title1 'orignal data' ; run;
proc sort data=a nodupkey ; by id; run;
proc print; title1 'after deleting dups id' ; run;
orignal data 1
16:09 Thursday, September 11, 1997
OBS ID
1 1
2 2
3 3
4 3
5 3
after deleting dups id 2
16:09 Thursday, September 11, 1997
OBS ID
1 1
2 2
3 3
______________________________ Reply Separator _________________________________
Subject: deleting duplicates
Author: Lynn Nicole Lethbridge <lynnl@IS.DAL.CA> at smtp-gateway
Date: 9/11/97 4:37 PM
Hi there
I have data where there are duplicates of observations. I'd like to get
rid of the duplicates which appear together. Included with the data are
unique identifiers for each observation. So for example in the following:
obs id
1 1
2 2
3 3
4 3
5 3
I'd like to get rid of obs 4 and 5.
The repeats always follow directly after the original observation which I
keep.
Thanks so much for any help.
Lynn
| 
