topic Re: changing date in SAS Programming

changing date

Dhana18 — Wed, 12 Feb 2020 18:10:31 GMT

Hi,

I have a date value under variable named DATETX like 03/13/2019 and i would like to change that date to 02/27/219. the date value now is MMDDYY10.

Re: changing date

PeterClemmensen — Wed, 12 Feb 2020 18:16:18 GMT

Where does 219 come from?

Re: changing date

svh — Wed, 12 Feb 2020 18:28:58 GMT

Sometimes I like to find the integer for the date, and then I use the data step to change the value of a date. E.g., I would use the following step to find the number and then do something like 'if datetx = 21621 then datetx=21607' in a data step.

data new;
input date  MMDDYY10.  ;
putlog _all_; /*this prints the integer values to the log*/
cards;
03/13/2019 
02/27/2019
;
run;

Re: changing date

Kurt_Bremser — Wed, 12 Feb 2020 18:33:31 GMT

So you want to subtract two weeks? When you need to shift a date by a given amount of a given interval, the intnx() function is the tool of choice.

Re: changing date

Dhana18 — Wed, 12 Feb 2020 18:51:02 GMT

Nope, I have a missing treatment info on 03/13/2019 and I found treatment info on another date 02/27/2019 so I wanted to do some thing like if id="123" then Datetx(treatment date) is 02/27/2019.

I tried

IF cl_eventid="3716489" then datetx="27Aug2019"d;

it did not give me an error in log but when I proc print the result was not like how I wanted

it was like this

cl_eventid Datetx

3716489 21788

Re: changing date

ballardw — Wed, 12 Feb 2020 18:56:15 GMT

@Dhana18 wrote:

Nope, I have a missing treatment info on 03/13/2019 and I found treatment info on another date 02/27/2019 so I wanted to do some thing like if id="123" then Datetx(treatment date) is 02/27/2019.

I tried

IF cl_eventid="3716489" then datetx="27Aug2019"d;

it did not give me an error in log but when I proc print the result was not like how I wanted

it was like this

cl_eventid Datetx

3716489 21788

You need to apply a date format to a SAS date value to display properly. Such as DATE9. or MMDDYY10.

If you do not have a default date format assigned and do not specify one in Proc Print then Print will default to BEST.

Try adding

foramt datetx mmddyy10. ;

to your proc print code.

If other values are displaying as you want but do not have a date format applied then likely you have a number that only resembles a date and more work is needed.