topic calculate same date different month, SAS date in SAS Programming

calculate same date different month, SAS date

avepo — Thu, 17 Jan 2019 04:10:48 GMT

Hi all,

I need to calculate SAS dates 3 month before and 3 month after given dates but not adding or subtracting 90 days

For example,

I would like to know the dates (3 month before and after) using the given dates

3 month before	Given date	3 month after
10/1/2017	1/1/2017	4/1/2017
11/1/2017	2/1/2017	5/1/2017
12/1/2017	3/1/2017	6/1/2017

Adding or subtracting 90 days do not give me the same dates with different months.

Does anyone know how to calculate these types of dates?

Thanks!

Re: calculate same date different month, SAS date

novinosrin — Thu, 17 Jan 2019 04:26:09 GMT

data want;

set have;

th3mthbfr=intnx('month', givrndate,-3,'s');

th3mthaftr=intnx('month', givrndate,3,'s');

format th3mthbfr th3mthaftr mmddyy10.;

run;

data want;

set have;

th3mthbfr=intnx('month', givrndate,-3);

thrmthaftr=intnx('month', givrndate,3);

run;

Re: calculate same date different month, SAS date

PGStats — Thu, 17 Jan 2019 04:23:28 GMT

Use the INTNX function:

date_before = intnx("MONTH", date, -3, "SAME");
date_after = intnx("MONTH", date, 3, "SAME");

Re: calculate same date different month, SAS date

avepo — Thu, 17 Jan 2019 10:32:27 GMT

Thanks! It worked.