EViews.com

Dear Sir,

I am trying to import cross-section identifiers in panel.

I use the following code :

'********************
'Import Panel Data
'********************
wfcreate(wf=eco_mod, page=annual) a 1982 2010 26
read(t=xls,a2,s=data_fin) C:\Users\Jamel\Latex\imbalances_and_feers_th\NEW_VERSION_0813\EXCEL_0215.xls country period mis reer feer reer_cs feer_cs
'*************************
genr logreer=log(reer)
genr logfeer=log(feer)
'*************************
equation level_reer_feer.ls logreer c logfeer
freeze(table_level_reer_feer) level_reer_feer
show level_reer_feer
'*************************************************
equation level_feer_reer.ls logfeer c logreer
freeze(table_level_feer_reer) level_feer_reer
show level_feer_reer
'************************************************************
equation difference_reer_feer.ls d(logreer) c d(logfeer)
freeze(table_diff_reer_feer) difference_reer_feer
show difference_reer_feer
'*************************************************************
equation difference_feer_reer.ls d(logfeer) c d(logreer)
freeze(table_diff_feer_reer) difference_feer_reer
show difference_feer_reer
'*************************************************************
group reer_feer logreer logfeer
freeze(mygra) reer_feer.scat(panel=combined) linefit
show mygra
'*************************************************************

The program works well but the country series which should be the series of cross-section identifiers display "NA" in every cells. I join the data to the message.

I think the problem comes from the fact the series of cross-section identifiers is not in a "number" format.

I didn't manage to solve this programming problem in a simple way.

Your help would be very useful.

Yours faithfully,

Jamel Saadaoui
University of Strasbourg

Hard to say without seeing the original source file, but you should almost certainly just be using a wfopen rather than a wfcreate followed by a read.

Thank you for your fast reply, I will try with wfcreate. I attach the original source file.

Problem solved. Thank you for your help.

Jamel Saadaoui
University of Strasbourg