Page 1 of 1

Import - Eviews converts numbers to dates

Posted: Tue Sep 15, 2015 9:26 am
by ErikG
Hi,

I've got an excel file with a column filled with numbers formatted as text. When importing the data to an unstructured Workfile Eviews converts these numbers to quarterly dates. This didn't happen about a year ago using Eviews 9. Can I force Eviews to read each column as a string?

Thanks,
Erik.

Re: Import - Eviews converts numbers to dates

Posted: Tue Sep 15, 2015 9:33 am
by EViews Gareth
Yes, on Step 2 of the Excel Read dialog you can use the Data Type box to change the type.

Re: Import - Eviews converts numbers to dates

Posted: Thu Nov 05, 2015 4:57 am
by ErikG
And in code how do I do this if I have different data types in different columns in the excel sheet?

/Erik.

Re: Import - Eviews converts numbers to dates

Posted: Thu Nov 05, 2015 5:01 am
by ErikG
OK, I See, this is the types option.