reshape panel data to pooled data

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

tinfah
Posts: 31
Joined: Fri Aug 12, 2011 10:23 pm

reshape panel data to pooled data

Postby tinfah » Thu Nov 29, 2018 8:59 am

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
Attachments
ifi-g2.WF1
(88.78 KiB) Downloaded 286 times

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

Re: reshape panel data to pooled data

Postby EViews Gareth » Thu Nov 29, 2018 9:28 am

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.
Follow us on Twitter @IHSEViews

tinfah
Posts: 31
Joined: Fri Aug 12, 2011 10:23 pm

Re: reshape panel data to pooled data

Postby tinfah » Thu Nov 29, 2018 10:26 am

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.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 10 guests