Replicate Series Creation from Excel

[dreavis]

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. :)

[EViews Gareth]

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.

[dreavis]

Thank you very, very much! :D