Page 1 of 1
Importing World Bank Panel Data
Posted: Sat Aug 10, 2013 1:29 pm
by abdurrub
Hi,
I have read the detailed guide of how to import data on an other topic but cannot the import the attached file into Eviews 7. Could someone please help me out here.
Re: Importing World Bank Panel Data
Posted: Sun Aug 11, 2013 5:46 pm
by EViews Gareth
Probably the easiest thing to do, if you're using EViews 7 rather than 8, is to transpose it manually in Excel, then put it into EViews.
Re: Importing World Bank Panel Data
Posted: Mon Aug 12, 2013 10:15 am
by abdurrub
I tried that first. But since its a panel data of 190 countries, I have to copy and transpose paste for every country one-by-one.
Is it still the easiest way possible?
Re: Importing World Bank Panel Data
Posted: Mon Aug 12, 2013 10:29 am
by EViews Gareth
If it were me, I'd just upgrade to EViews 8
Re: Importing World Bank Panel Data
Posted: Mon Aug 12, 2013 11:56 am
by abdurrub
will the beta version do?
the process in EVIEWS 8 BETA is straight forward?
Re: Importing World Bank Panel Data
Posted: Mon Aug 12, 2013 11:59 am
by EViews Gareth
The Beta version will no longer work.
Re: Importing World Bank Panel Data
Posted: Mon Aug 12, 2013 12:58 pm
by EViews Gareth
But, if you do get EViews, this code will make both a pooled page and a panel page:
Code: Select all
wfopen(page=pool) "inflation version 2.xlsx" byrow colhead=2 namepos=last @rename country_code year
pagestruct @date(year)
%cxlist = @wlookup("???", "series")
pagestack(page=panel) {%cxlist}
rename var02 inflation
Re: Importing World Bank Panel Data
Posted: Mon Aug 12, 2013 1:44 pm
by abdurrub
Thank you Gareth. :)
Also, I found Tableau add-in for excel to do the trick of reshaping this wide data into long which can be easily imported into eviews.
