Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

Want to keep one record of ID and unique date

Accepted Solution Solved
Reply
Contributor
Posts: 71
Accepted Solution

Want to keep one record of ID and unique date

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


Accepted Solutions
Solution
‎09-16-2011 12:55 PM
Super User
Super User
Posts: 7,074

Want to keep one record of ID and unique date

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;

View solution in original post


All Replies
Solution
‎09-16-2011 12:55 PM
Super User
Super User
Posts: 7,074

Want to keep one record of ID and unique date

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;

🔒 This topic is solved and locked.

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

Discussion stats
  • 1 reply
  • 187 views
  • 0 likes
  • 2 in conversation