topic Re: Set to missing if date is a repeat in SAS Programming

Set to missing if date is a repeat

AncaTilea — Wed, 30 Jan 2013 19:15:57 GMT

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

;

data want;

3021 20SEP2001

3021 20NOV2001

3021 20FEB2002

3021 .

;

Thank you!

Re: Set to missing if date is a repeat

AncaTilea — Wed, 30 Jan 2013 19:21:25 GMT

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:

Re: Set to missing if date is a repeat

DBailey — Wed, 30 Jan 2013 19:22:41 GMT

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;

Re: Set to missing if date is a repeat

AncaTilea — Wed, 30 Jan 2013 19:24:02 GMT

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!

Re: Set to missing if date is a repeat

AncaTilea — Wed, 30 Jan 2013 19:31:40 GMT

Thank you.

Once I posted it, I figured it out myself.