Date Recognition in Panel Import

[rmoralesaramburu]

Hi,

I am having troubles when I import data to excel, Eviews can't recognize properly the dates column. Could you help me please? I am attaching the excel file.

[EViews Gareth]

The date column is messed up in Excel. If you change the format of Column A to be "General" rather than "Date", you'll see that only some of the values are actual dates, and others are text. This is screwing with EViews. It would be easier to fix in Excel than in EViews, probably.

[rmoralesaramburu]

Thanks for the reply. It has been difficult for me changing the format of the dates. In Eviews I have the following Error Message "Try Using GENR functions with explicit formatting to create a date series in "PAGESTRUCT COUNTRY @DATE(DATE)".

How can I do that?

I have the panel and the only thing I can't get are the dates. I would like to do it manually, it is weekly data from 10/27/2000 till 04/01/2015

Thanks!!

[EViews Gareth]

Did you try fixing it in Excel?

[rmoralesaramburu]

Yes! with no success! So I prefer to do it manually in eviews if it is straightforward and easy..

[EViews Gareth]

Try:

Code: Select all

series dt = @dateval(date)

then using dt as the date series.