## Adding Months to a Date

Solved
Frequent Contributor
Posts: 92

# Adding Months to a Date

This is probably an easy answer, but how does one add months to a date variable.

Example:

suppose date_start='01Aug2015'd and I use this as the ending point for my historical data. When I build my model and use the lead=12 option for my arima forecast, I'd like to be able to use that 12 in the lead statement to autiomatically calculate a bound for using the band command to shade in the forecast area in sgplot.

So I need to be able to take that 12 and add it to date_start. I don't seem to be able to use:

date_end=date_start + 12,

So how can I add twelve months to date_start? I actually have a variable called lead_var that passes the lead value so I can change it in one place as a global variable and it will affect all arima calls. So in effect I need to be able to use:

with lead_var=12 in this case.

Thanks again for all your help. These forums are amazing!

-Bill

Accepted Solutions
Solution
‎06-12-2017 10:35 AM
PROC Star
Posts: 8,163

## Re: Adding Months to a Date

```data have;
input date date9.;
format date date9.;
cards;
2feb2017
3apr2016
;
data want;
set have;
format newdate date9.;
newdate=intnx('month',date,12,'s');
run;
```

Art, CEO, AnalystFinder.com

All Replies
Solution
‎06-12-2017 10:35 AM
PROC Star
Posts: 8,163

## Re: Adding Months to a Date

```data have;
input date date9.;
format date date9.;
cards;
2feb2017
3apr2016
;
data want;
set have;
format newdate date9.;
newdate=intnx('month',date,12,'s');
run;
```

Art, CEO, AnalystFinder.com

Frequent Contributor
Posts: 92

## Re: Adding Months to a Date

thank you!

This worked perfectly

☑ This topic is solved.

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

Discussion stats
• 2 replies
• 6519 views
• 1 like
• 2 in conversation