sampling

[NurfatimaD]

Hello!

Is there any way to say EViews to perform the following task without changing the sample size manually hundred times.
I have a set of forecasts up to 12 months ahead (for example, a forecast for September 2012 to August 2013). I need to divide each of them by the current value of an index (that is, one on August 2012).

The example data:
Date Actual Forecast
2012M08 221.4747 221.4747
2012M09 NA 222.3697
2012M10 NA 223.6941
2012M11 NA 225.0851
2012M12 NA 226.7863
2013M01 NA 228.6525
2013M02 NA 230.5157
2013M03 NA 232.1210
2013M04 NA 233.6691
2013M05 NA 235.0810
2013M06 NA 235.6956
2013M07 NA 236.4603
2013M08 NA 236.9440

[EViews Gareth]

not sure I follow. Something like:

Code: Select all

series new_forc = forc / @elem(forc, "2012m08")

where forc is the name of your existing forecast series.