BookmarkSubscribeRSS Feed
mdavidson
Quartz | Level 8
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.
1 REPLY 1
mdavidson
Quartz | Level 8
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;

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1447 views
  • 0 likes
  • 1 in conversation