Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Home
- /
- Analytics
- /
- Forecasting
- /
- Getting confidence Intervals

Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

🔒 This topic is **solved** and **locked**.
Need further help from the community? Please
sign in and ask a **new** question.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Posted 01-06-2016 09:23 AM
(2025 views)

I have monthly deactivation data and i want to forecast 6 months into the future with SAS forecast studio for desktop. If a month has more weekend days this year then deactivations will be lower / if less weekend days in the month the more deactivations. one way i thought of taking care of this is to calculate avg daily deactivations each month (based on working days of the month) then multiply the predictions by the working days in each predicted month. Question is How can i calculate the new Confidence Intervals?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

i just took a look that the data, i don't think the data in the forecast horizon periods are populated correctly.

1. I assumed the Region is the BY variable. There should be no missing values in the horizon periods.

2. You should populate the weekdays variable for each of the BY variable.

Please take a look at the attached worksheet with the correct horizon data.

11 REPLIES 11

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

There are 2 approaches on top of my head:

1. create an input variable "number of weekend days" and incorporate it into the model (has to be either UCM or ARIMA)

2. Use the ADJUSTMENT option to first pre-adjust the monthly series, forecast the adjusted series, and post-adjust the forecasts. Forecast studio will compute the adjusted CI for you.

1. create an input variable "number of weekend days" and incorporate it into the model (has to be either UCM or ARIMA)

2. Use the ADJUSTMENT option to first pre-adjust the monthly series, forecast the adjusted series, and post-adjust the forecasts. Forecast studio will compute the adjusted CI for you.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

you will need to populate the input/adjustment variables for the forecast horizon periods, not just the historical periods.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

would you be able to share the data with me? Something is missing but it is hard to tell from the forecast plot. thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

find attached.

thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

X1 is the dependent var

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

i just took a look that the data, i don't think the data in the forecast horizon periods are populated correctly.

1. I assumed the Region is the BY variable. There should be no missing values in the horizon periods.

2. You should populate the weekdays variable for each of the BY variable.

Please take a look at the attached worksheet with the correct horizon data.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

thank you!!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

See if you can switch to more granular data at all, if you have daily data, it may be worth working at a week level.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

at this point can't get more granular data.

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

**If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. **

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.