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.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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