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
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;
Jan 26 is a Sunday, Jan 30th is Thursday.
What's the logic behind your change?
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?
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;
Thank a lot Reeza... I was working some datasets and needed to change the date.
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.