BookmarkSubscribeRSS Feed
lucky66
Calcite | Level 5

Hi all, 

 

I have a time series data and trying to use proc ucm to generate some output, but I am not sure how to implement those output for seasonality into new datasets.  The output related to seasonality is like this: Anyone knows how to implement seasonality into to new data forecasting/scoring? Thank you. 

Significance Analysis of Components (Based
on the Final State)
Component DF Chi-Square Pr > ChiSq
Irregular 1 0.3 0.2
Season 4 20 <.0001
Summary of Seasons
Name Type Season Length Error Variance
Season TRIG 12 0

 

and SAS code like this:

proc ucm data=a;              
  id date interval=month;          
  irregular;              
  season length=12 variance=0 noest type=trig keeph=1 2 plot=smooth print=smooth;
  model b=var1 var2 var3;          
  estimate plot=wn plot=panel plot=model outtest=outdata;      
run;                
2 REPLIES 2
lucky66
Calcite | Level 5

 

I have a time series data and trying to use proc ucm to generate some output, but I am not sure how to implement those output for seasonality into new datasets.  The output related to seasonality is like this: Anyone knows how to implement seasonality into to new data forecasting/scoring? Thank you. 

Significance Analysis of Components (Based
on the Final State)
Component DF Chi-Square Pr > ChiSq
Irregular 1 0.3 0.2
Season 4 20 <.0001
Summary of Seasons
Name Type Season Length Error Variance
Season TRIG 12 0

 

and SAS code like this:

proc ucm data=a;              
  id date interval=month;          
  irregular;              
  season length=12 variance=0 noest type=trig keeph=1 2 plot=smooth print=smooth;
  model b=var1 var2 var3;          
  estimate plot=wn plot=panel plot=model outtest=outdata;      
run;                
rselukar
SAS Employee

I don't fully follow your question.  In any event, I am offering an answer based
on what I think you are asking.  The suggested answer is only an adhoc process
and I don't have personal experience of using this technique.

 

I have heard of some cases where seasonal indices of one series are used as a
proxy for seasonal indices of other series, presumably because of the lack of sufficient
data in the other series.  Of course, this would make sense only if the two series
are similar in some sense, e.g., monthly sales of an item of two different brands.  Even
in such cases, because of the differences in the scales of mean patterns of the
two series it is important to model the series in the log scale (multiplicative form in
the original scale)
so that the seasonal indices have the interpretation of percentage change.  Assuming that
all these conditions are met, you could use this strategy as follows:

 

1. Fit a seasonal model to the log-transformed version of series 1 (the
one that has sufficient data).  Read off the smoothed seasonal component (the s_season
column) from the OUTFOR= data set in the FORECAST statement.
2. Fit a non-seasonal model to the log-transformed version of series 2.  Add the
smoothed seasonal component of the first series to the forecasts of the second series.
This would adjust the forecasts of the second series according to the seasonal
pattern of the first series.

 

Hope this helps.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 930 views
  • 0 likes
  • 2 in conversation