topic Re: changing date value in SAS Enterprise Guide

changing date value

woo — Mon, 24 Nov 2014 00:02:18 GMT

Hello friends,

please help me to change this value for date. date variable is "date type"

have value

date=Sun, Jan 26, 2014

want value

date=Sun, Jan 30, 2014

Thank you

Reeza — Mon, 24 Nov 2014 00:05:39 GMT

Jan 26 is a Sunday, Jan 30th is Thursday.

What's the logic behind your change?

woo — Mon, 24 Nov 2014 00:29:25 GMT

yes sorry i missed the day

so from Sun, Jan 26, 2014 to Thu, Jan 30, 2014

how can i change this using SAS code?

Reeza — Mon, 24 Nov 2014 00:37:00 GMT

Again what's the logic, is it for only one date?

You can use the intnx function to increment a date 4 days, or simply add 4 to the date.

data Sample;

have="26Jan2014"D;

want=intnx('day', have, 4);

want2=have+4;

format have want want2 weekdate17.;

put have;

put want;

put want2;

run;

woo — Mon, 24 Nov 2014 06:26:23 GMT

Thank a lot Reeza... I was working some datasets and needed to change the date.