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 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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
  • 2 replies
  • 1110 views
  • 0 likes
  • 2 in conversation