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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.