Panel data import from Excel
Posted: 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?
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?