Want to keep one record of ID and unique date

[HyunJee]

I have a dataset with repeated IDs and dates.

Example

ID               Date

2               09/09/11

2               09/09/11

2               10/01/11

2               10/01/11

2               12/01/11

5               09/09/11

5              09/09/11

5              10/01/11

5              10/01/11

5               12/01/11

9               09/09/11

9               09/09/11

9               10/01/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 · Accepted solution]

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;