Linking New Series with an old Series (EV6)
Posted: Thu Jan 28, 2010 12:17 am
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
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