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-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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