Creating a Daily Forecast

mdavidson — Thu, 03 Jun 2010 15:15:23 GMT

Hello --

I'm relatively new to forecasting so I'm looking for some help. I'd like to create a daily volume forecast; I have lots of historical data.

I'm using SAS EG 4.1, so I don't have SAS Forecast Studio.

Here's the problem. I'm currently able to create a fairly accurate MONTHLY forecast using PROC STATESPACE and a few data steps. I'd like to translate this into a daily forecast, or if possible use PROC STATESPACE to create my daily forecast.

My data is seasonal. For example Jan, Feb, and Mar are busy months. Saturday is a light day, Tuesday is the busiest day.

Any suggestions? I've been doing a ton of searching on the web, but can't seem to find anything.

Re: Creating a Daily Forecast

mdavidson — Thu, 03 Jun 2010 19:41:45 GMT

I seem to be getting a better result with 28 in my var declaration. I'm brand new to proc statespace, so if you see anything below that is a SAS no-no please let me know.

This code sets up the variables I'm using to forecast out the coming 14 days.

PROC STATESPACE
DATA=TEST1
OUT=TEST2
LEAD=14;
VAR LOG(1,28);
ID OBS;
RUN;

topic Re: Creating a Daily Forecast in Statistical Procedures

Creating a Daily Forecast

Re: Creating a Daily Forecast