manipulation of forecast series
Posted: Mon Jul 29, 2013 6:44 am
Hello,
I'm trying to figure out an efficient way to manipulate the forecast series of multiple variables. For example I'd like to increase/decrease the out of sample values of the variable apples by 10% to do some "sensitivity testing".
The only way I have come up with is the following:
where there is already a series called apples where the sample period 1990q1 - 2013q1 are my in sample actuals and the forecast period (forecasts already in the series) is 2013q2 2016q4
smpl 1990q1 2013q1
apples_inc10 = apples
apples_dcr10 = apples
smpl 2013q2 2016q4
apples_inc10 = apples*1.1
apples_dcr10 = apples *.90
This give me two series with the same in sample values and with the forecasted values 10% above and and below the orginal forecasted values.
For a high number of variables, is there an easier way to do this? Is there a 'select all' variables command I could use?
Version: 7.2
Thanks,
I'm trying to figure out an efficient way to manipulate the forecast series of multiple variables. For example I'd like to increase/decrease the out of sample values of the variable apples by 10% to do some "sensitivity testing".
The only way I have come up with is the following:
where there is already a series called apples where the sample period 1990q1 - 2013q1 are my in sample actuals and the forecast period (forecasts already in the series) is 2013q2 2016q4
smpl 1990q1 2013q1
apples_inc10 = apples
apples_dcr10 = apples
smpl 2013q2 2016q4
apples_inc10 = apples*1.1
apples_dcr10 = apples *.90
This give me two series with the same in sample values and with the forecasted values 10% above and and below the orginal forecasted values.
For a high number of variables, is there an easier way to do this? Is there a 'select all' variables command I could use?
Version: 7.2
Thanks,