Page 1 of 1

From stacked data to time series

Posted: Mon Sep 26, 2016 3:13 am
by karipe
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

Re: From stacked data to time series

Posted: Mon Sep 26, 2016 7:52 am
by EViews Gareth
Could you provide your workfile?

Re: From stacked data to time series

Posted: Tue Sep 27, 2016 12:21 am
by karipe
Of course, please find the file attached.

Kari

Re: From stacked data to time series

Posted: Tue Sep 27, 2016 9:09 am
by EViews Gareth
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.