BookmarkSubscribeRSS Feed
mmyrto
Quartz | Level 8

Im using time series to forecast deactivations using forecast studio. I have data for two years. I also have activations data which im using as an input. so deactivations are showing decreasing trend only because our base is decreasing in essense based on out total units they r not decreasing but increasing. Any ideas on how to make this clear?

 

Thank you

2 REPLIES 2
alexchien
Pyrite | Level 9

there are 2 ways to accomplish what you wanted:

1. you can populate the future input varaible values to the "base" value (e.g. 0). The forecasts should be the "base" forecasts. You can then test if the base forecasts are trending up or down

 

2. you can use UCM model (excluding ARIMA and ESM) and look at the OUTCOMPONENT dataset. Filter the OUTCOMPONENT dataset with _COMP_ = 'Filtered Level' and examine the _PREDICT_ column. This component is basically the "base foreccasts" without the influence of input variables. 

 

thanks

Alex

Puwang
Obsidian | Level 7

Is there any reason/indicator which tells you that deactivations should be increasing? It would help the model identify increasing trend if you add that indicator as an independent variable to your model.

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
  • 1195 views
  • 0 likes
  • 3 in conversation