Panel data import from Excel

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

stefanp
Posts: 63
Joined: Wed Sep 30, 2015 12:24 am

Panel data import from Excel

Postby stefanp » Thu Jan 28, 2016 9:58 am

Hey guys,

I have a spreadsheet containing panel data (24 months, countries + sectors and one variable with a value for each combination (time, country, sector))

I've been struggling to import the data as described below:

http://www.eviews.com/Learning/workfiles_b.html

Contrary to the guide, Eviews does not recognize that the source data was a panel. If I proceed to step 3 of 3 of the "Excel read" function and select "Dated Panel" (Basic structure), I need to specify the Panel identifier series which I am not able to do.

Any ideas how to continue?

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

Re: Panel data import from Excel

Postby EViews Gareth » Thu Jan 28, 2016 10:13 am



Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests