Want to keep one record of ID and unique date

HyunJee — Fri, 16 Sep 2011 16:53:10 GMT

I have a dataset with repeated IDs and dates.

Example

ID Date

2 09/09/11

2 10/01/11

2 12/01/11

5 09/09/11

5 10/01/11

5 12/01/11

9 09/09/11

9 10/01/11

9 12/01/11

I want it to look like this:

2 09/09/11

2 10/01/11

2 12/01/11

5 09/09/11

5 10/01/11

5 12/01/11

9 09/09/11

9 10/01/11

9 12/01/11

I want to keep each line of data for each ID that contains a dfifferent date.

Thank you for any help you can give.

HyunJee

Tom — Fri, 16 Sep 2011 16:55:33 GMT

try one of these three methods.

data want;

set have;

by id date;

if first.date;

run;

proc sql;

create table want as select distinct id,date from have;

quit;

proc sort data=have out=want nodupkey ;

by id date;

run;

topic Want to keep one record of ID and unique date in SAS Data Science