Desktop productivity for business analysts and programmers

changing date value

Accepted Solution Solved
Reply
Super Contributor
Super Contributor
Posts: 331
Accepted Solution

changing date value

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


Accepted Solutions
Solution
‎11-23-2014 07:37 PM
Super User
Posts: 19,038

Re: changing date value

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;

View solution in original post


All Replies
Super User
Posts: 19,038

Re: changing date value

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

What's the logic behind your change?

Super Contributor
Super Contributor
Posts: 331

Re: changing date value

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?

Solution
‎11-23-2014 07:37 PM
Super User
Posts: 19,038

Re: changing date value

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;

Super Contributor
Super Contributor
Posts: 331

Re: changing date value

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 332 views
  • 1 like
  • 2 in conversation