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
From stacked data to time series
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13317
- Joined: Tue Sep 16, 2008 5:38 pm
Re: From stacked data to time series
Could you provide your workfile?
Follow us on Twitter @IHSEViews
Re: From stacked data to time series
Of course, please find the file attached.
Kari
Kari
- Attachments
-
- k2_mnd.wf1
- (73.83 KiB) Downloaded 210 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13317
- Joined: Tue Sep 16, 2008 5:38 pm
Re: From stacked data to time series
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.
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
Who is online
Users browsing this forum: No registered users and 21 guests