Cross-section identifiers in panel data (Programming)

[Jamels]

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

[EViews Gareth]

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.

[Jamels]

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

[Jamels]

Problem solved. Thank you for your help.

Jamel Saadaoui
University of Strasbourg