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:
date_end=date_start + lead_var
with lead_var=12 in this case.
Thanks again for all your help. These forums are amazing!
-Bill
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
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
thank you!
This worked perfectly
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.