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
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
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.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.