Page 1 of 1
Date Recognition in Panel Import
Posted: Thu Apr 09, 2015 8:51 am
by 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.
Re: Date Recognition in Panel Import
Posted: Thu Apr 09, 2015 1:04 pm
by 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.
Re: Date Recognition in Panel Import
Posted: Mon Apr 13, 2015 7:01 am
by 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!!
Re: Date Recognition in Panel Import
Posted: Mon Apr 13, 2015 8:15 am
by EViews Gareth
Did you try fixing it in Excel?
Re: Date Recognition in Panel Import
Posted: Mon Apr 13, 2015 11:45 am
by rmoralesaramburu
Yes! with no success! So I prefer to do it manually in eviews if it is straightforward and easy..
Re: Date Recognition in Panel Import
Posted: Mon Apr 13, 2015 11:54 am
by EViews Gareth
Try:
then using dt as the date series.