From stacked data to time series

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

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

karipe
Posts: 2
Joined: Mon Sep 26, 2016 2:45 am

From stacked data to time series

Postby karipe » Mon Sep 26, 2016 3:13 am

Hello,

I've imported the dataset http://data.ssb.no/api/v0/dataset/166324.csv?lang=no as stacked data, and since there are four variables they get the cross-section id's 1 to 4. I want to split these four series into four time series with individual names, and therefore I have two questions:

1. How do you change the crossid names from 1-4 to string variable names (as in a pooled data set I saw in this forum they GDP variable was divided into FRA, ENG etc)?
2. Is it possible to divide the stacked data into four series with individual names?

Thank you in advance for any help or guidance.

Regards,
Kari

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

Re: From stacked data to time series

Postby EViews Gareth » Mon Sep 26, 2016 7:52 am

Could you provide your workfile?
Follow us on Twitter @IHSEViews

karipe
Posts: 2
Joined: Mon Sep 26, 2016 2:45 am

Re: From stacked data to time series

Postby karipe » Tue Sep 27, 2016 12:21 am

Of course, please find the file attached.

Kari
Attachments
k2_mnd.wf1
(73.83 KiB) Downloaded 210 times

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

Re: From stacked data to time series

Postby EViews Gareth » Tue Sep 27, 2016 9:09 am

1. Create an alpha series containing the labels you want to use for the cross-sections, then click on Proc->Structure/Resize Current Page and enter the name of the alpha series as the cross-section identifier.

2. In general, Proc->Reshape Current Page->Unstack in New page.

However, in your case the data for each cross-section are identical, so you won't get 4 different series.
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 21 guests