aggregating years in panel data
Posted: Mon Jul 14, 2014 9:59 pm
by ads
Hello, I have panel data for a number of variables (gdp, population growth etc), my cross-section is countries and the period is years. I wish to aggregate the variables into 5-year periods. Is there a way of doing this in Eviews?
thanks
Re: aggregating years in panel data
Posted: Tue Jul 15, 2014 8:03 am
by EViews Gareth
Create a new page in your workfile with a structure of dated panel, with a 5-yearly frequency, and the same number of cross-sections. In each page create a new series:
Then copy from the first page to the new page, using general-match-merge as the copy criteria, and "dateid" and "id" as the two id series. Use SUM as the contraction method.