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
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;
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.
Find more tutorials on the SAS Users YouTube channel.