Hi.
How can I set to missing the dates that repeat?
data in;
informat ckd_dt date9.;
format ckd_dt date9.;
input c_id ckd_dt date9.;
cards;
3021 20SEP2001
3021 20NOV2001
3021 20FEB2002
3021 20FEB2002
3021 20FEB2002
;
data want;
3021 20SEP2001
3021 20NOV2001
3021 20FEB2002
3021 .
3021 .
;
Thank you!
proc sort in=in out=in;
by c_id ckd_dt;
run;
data want;
set in;
by c_id ckd_dt;
if not first.ckd_dt then ckd_dt=.;
run;
OK,
I got it.
Thank you.
proc sort data = in;by c_id ckd_dt;
data want;
set in;
by c_id ckd_dt;
if first.ckd_dt then new_dt = ckd_dt;
else new_dt= .;
run;
:smileyplain:
proc sort in=in out=in;
by c_id ckd_dt;
run;
data want;
set in;
by c_id ckd_dt;
if not first.ckd_dt then ckd_dt=.;
run;
Thank you.
Once I posted it, I figured it out myself.
ok,I got it.
Sorry for taking any of your time.
proc sort data = in;by c_id ckd_dt;
data want(drop = ckd_dt rename = (new_dt = ckd_dt))
set in;
by c_id ckd_dt;
if first.ckd_dt then new_dt = ckd_dt;
else new_dt= .;
run;
Thanks!
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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.