topic Re: Date calculation in SAS Programming

Date calculation

ZZB — Thu, 22 Jan 2015 18:02:30 GMT

Hello,

I want to add 1-month (or X-month) to original date. Is there any simple and efficient way to deal with it?

31/10/2001 --> 30/11/2001

30/11/2001 --> 31/12/2001

31/12/2001 --> 31/01/2002

31/01/2002 --> 28/02/2002

......

Thanks

slchen — Thu, 22 Jan 2015 18:20:26 GMT

newdate=intnx('month', olddate,1, 'same');

PGStats — Thu, 22 Jan 2015 18:20:39 GMT

Use function INTNX with "SAME" or "END" parameter :

data have;

input (inDate outDate) (:ddmmyy.);

format inDate outDate ddmmyy10.;

datalines;

31/10/2001 30/11/2001

30/11/2001 31/12/2001

31/12/2001 31/01/2002

31/01/2002 28/02/2002

15/02/2002 .

;

data want;

set have;

format newDate endDate ddmmyy10.;

newdate = intnx("MONTH", inDate, 1, "SAME");

enddate = intnx("MONTH", inDate, 1, "END");

run;

proc print data=want noobs; run;