Linking New Series with an old Series (EV6)

[Riaz]

EViews V6 Query

Hi

(My query is related to the attached EV6 file)

I have 2 series; they are both Quarterly Earnings (nominal dollars). The new series came about due to changes in the income date collection methodology.

The new series (awe_n) is from 1994q3 2009q3.
The old series (awe_o) is from 1983q4 2009q2.

I want to extend the NEW series from 1994q2 backwards to 1983q4.

(1) Could you please suggest an EViews proc to do that.

Alternatively,

(2) How could I use the following formula to extend the new series backwards? This is an extension based on a simple growth rate on the old series.

((awe_o 1994q2/awe_o 1994q3)*awe_n 1994q3)

The above computation is just for 1994q2 cell in awe_n. But I want to compute for all the cells from 1994q2 to 1983q4.

Cheers, Riaz

[EViews Gareth]

Code: Select all

smpl 1983q4 1994q2 awe_n = awe_o

[Riaz]

Thanks.

Can you suggest a way of doing the second option that I have proposed?

Cheers.