Generating a new series from the last observation of several time-series

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Jason, EViews Moderator, EViews Pamela

min_econ
Posts: 1
Joined: Wed Sep 06, 2017 5:07 am

Generating a new series from the last observation of several time-series

Postby min_econ » Wed Sep 06, 2017 8:03 am

I have a number of time series variables of the following shape (which I've fetched from macrobond):

PCTY15_74total_atra
2016Q1 67.3973949207206
2016Q2 67.618426882372
2016Q3 67.8003137246444
2016Q4 67.8052517789873
2017Q1 67.7539846408431

Each time-series contains data for one country. I want to generate a new series (in a new page) which contains the ultimate observation of each series. So the new series would look something like this:

var2017Q1
PCTY15_74TOTALATRA 64.5
PCTY15_74TOTALBERA 59.8
PCTY15_74TOTALBGRA 57
PCTY15_74TOTALCYRA 67.7
PCTY15_74TOTALCZRA 63.6
PCTY15_74TOTALDKRA 72.5
PCTY15_74TOTALEERA 66.2
PCTY15_74TOTALELRA 58.5
PCTY15_74TOTALESRA 63.9
PCTY15_74TOTALDERA 65.1

Is this possible to do? Preferable by way of programming, since this is part of a program I'm writing.

Thanks in advance!

/Eviews newbie

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11410
Joined: Tue Sep 16, 2008 5:38 pm

Re: Generating a new series from the last observation of several time-series

Postby EViews Gareth » Wed Sep 06, 2017 8:15 am

Probably the easiest thing to do would be to use pagestack to convert your current pool structure into a new panel page, then pagecontract to lop off all the time series elements apart from the last.
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 6 guests