Page 1 of 1
reshape panel data to pooled data
Posted: Thu Nov 29, 2018 8:59 am
by tinfah
I have a problem, trying to reshape my panel data which comprises 79 cross section and 7 years to a pooled data. I have 11 variables there - TC, EL, IS, GE, PGDP, GAP, IFI1, IFI2, IFI3, EF.
The file is attached below. Can you help?
Tq
Re: reshape panel data to pooled data
Posted: Thu Nov 29, 2018 9:28 am
by EViews Gareth
The issue is that you have a series IFI, and IFI1, IFI2, IFI3, and that your cross-sections are labelled 1,2,3,... When you do a standard unstack, the series IFI will be unstacked to IFI1, IF2, IF3, ... but they already exist as other series.
Renaminng IFI1,2,3 in the source page should fix the issue.
Re: reshape panel data to pooled data
Posted: Thu Nov 29, 2018 10:26 am
by tinfah
My kudos to you for your help. Yes, I didn't realize the naming of the variables can give me so much trouble because I was checking on other issues like the steps in involved.
Thank you, once again.