EViews.com

Posted: **Thu Jun 19, 2014 6:04 am**

I am migrating all data creation out of Excel and into Eviews, for increased speed and accuracy. Now, instead of copying and pasting from IHS data downloaded from the IHS site to a series of spreadsheets, I am extracting the series right out of the databanks as needed. (I love that!)

I have reached a point that I don't know how to reproduce what has been done in Excel... I need to create a new series from an existing series calculated in Eviews, where the new series observations are equal to the existing series through 2013q4, then 2014q1,2014q2,2014q3,and 2014q4 are equal to 2013q4. Then 2015q1,2015q2,2015q3,and 2015q4 are equal to 2014q4. And finally, 2016q1,2016q2,2016q3,and 2016q4 are equal to 2015q4. I am attaching a mock-up to help visualize what I need to do.

Thanks in advance to anyone who can help me. I really appeciate it. :)

Posted: **Thu Jun 19, 2014 8:15 am**

Needs a few lines of code:

Code: Select all


smpl 2010 2013
series y2 = y

smpl 2014 @last
y2 = @recode(@quarter=1, y(-1), y2(-1))
smpl @all

Where Y is the original series, Y2 is the new one.

Posted: **Thu Jun 19, 2014 10:41 am**

Thank you very, very much! :D

EViews.com

Replicate Series Creation from Excel

Replicate Series Creation from Excel

Re: Replicate Series Creation from Excel

Re: Replicate Series Creation from Excel