compute the average of the previous year in a monthly series

[eviewsuserforum]

Hopefully my question fits in this subforum.

I have been stuck with what is probably dumb.

I have a monthly time series say from 2010m1 to 2016m12.

For each month throughout year Y, I need Eviews to return the Jan-Dec average of year Y-1

eg, if mean for 2014 is 5, I need Eviews to return 5 for months Jan-15 to Dec-15 to be set to 5.

and I would like to avoid creating new object. gloups!

Can someone help please?

[startz]

Code: Select all

series annualMeans = @meansby(y,@year) series laggedAverage = annualMeans(-12)

Maybe...