SAS Forecasting and Econometrics

Forecasting using SAS Visual Forecasting, SAS Forecast Server, SAS Econometrics and more
BookmarkSubscribeRSS Feed
A_S
Fluorite | Level 6 A_S
Fluorite | Level 6

I have 50000 time series with seasonal trends and missing values. I would like to use seasonality to impute the missing values.

Please let me know if SAS has a proceedure for this.

 

The data is output from PROC TIMESERIES (interval = week).

The data covers 15 or 16 years (depends on which time series).

The seasonal patterns are all one year long (a period of one year, and correspond to spring, summer, autumn and winter).

Some of the gaps cover an entire season for a year, but other years have the corresponding season data (summer 2015 is missing; but summer 2014 and summer 2016 are not missing).

 

Because of the missing seasons, I am unsure if PROC EXPAND's methods will give reasonable results.

Would PROC MI's MCMC give solid results?

Initially, I used PROC HPSUMMARY to find monthly medians and imputed. Unfortunately, a collaborator objects to the four-week stair patterns.

 

Thank you!

2 REPLIES 2
alexchien
Pyrite | Level 9

One approach you can consider is to use a forecasting model to impute the historical missing values. For example, you can use PROC ESM with method = WINTERS to forecast the series. You will get not only the furture forecasts but also in-sample fit for the entire history including the missing value periods. You can use the in-sample fit to imput the historical missing values.

Alex

A_S
Fluorite | Level 6 A_S
Fluorite | Level 6

Thank you! the results look good!

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

Discussion stats
  • 2 replies
  • 1319 views
  • 0 likes
  • 2 in conversation