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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.