Importing World Bank Panel Data

[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.

[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.

[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?

[EViews Gareth]

If it were me, I'd just upgrade to EViews 8

[abdurrub]

will the beta version do?
the process in EVIEWS 8 BETA is straight forward?

[EViews Gareth]

The Beta version will no longer work.

[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

[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.