BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Forecaster
Obsidian | Level 7

I have a forecasting task at hand that has multiple seasonality. As an example, hour of the day, day of the week, week of the month, and month of the year. Is there a SAS forecast procedure that can handle multiple seasonality, I have access to SAS forecast server, SAS /ETS. I tries using Proc UCM but it is very slow.

Thanks for your help, much appreciated

1 ACCEPTED SOLUTION

Accepted Solutions
udo_sas
SAS Employee

Hello -

UCM can be slow with hourly data due to the size of the state vector.

Alternatively you may want to break up the problem into several modeling runs - one for each seasonality pattern which you have in mind - and then reconcile these different forecasts of different frequencies using the HPFRECONCILE procedure (assuming you have access to SAS Forecast Server).

Thanks,

Udo

View solution in original post

6 REPLIES 6
stat_sas
Ammonite | Level 13

What is the time interval for your data like daily,monthly, yearly?

stat_sas
Ammonite | Level 13

After plotting your hourly data, how do you determine daily, monthly, yearly seasonality?

Forecaster
Obsidian | Level 7

Visual inspection and business domain knowledge.

This is common in Call center activity data and electricity demand data. @stat@sas do you know of a procedure in SAS that would address multiple seasonality.

stat_sas
Ammonite | Level 13

First I am trying to understand how hourly plotted data on the graph can have multiple seasonality factors. If there is some seasonality in the data it should be hourly not daily, montly or daily unless there is some method which can sum up 24 hours to one day, 7 days to one week etc. on the graph which does not seem to be a possibility. May be other experts can suggest some solution for this sort of problem.

udo_sas
SAS Employee

Hello -

UCM can be slow with hourly data due to the size of the state vector.

Alternatively you may want to break up the problem into several modeling runs - one for each seasonality pattern which you have in mind - and then reconcile these different forecasts of different frequencies using the HPFRECONCILE procedure (assuming you have access to SAS Forecast Server).

Thanks,

Udo

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Discussion stats
  • 6 replies
  • 2195 views
  • 1 like
  • 3 in conversation