Wrong datatype in CSV import
Posted: Tue May 29, 2012 9:42 am
Hi all
I face a problem when importing data from a CSV file to Eviews 6 that I have not come across yet.
The CSV file is organized as a stacked panel file (monhtly data) and I have about 6 variables in the file which should all have numeric datatypes. But somehow, Eviews incorrectly recognizes two of the variables as characters even though they're exactely the same as the other 4. I have also made sure in Excel that they all have numeric cell format, but this doesn't help.
Do you have any idea why Eviews is not importing these two variables correctly? I have many NA in the file, as it's unbalanced. But this is also the case for the 4 variables that are correctly recognized.
Your help is highly appreciated!
I face a problem when importing data from a CSV file to Eviews 6 that I have not come across yet.
The CSV file is organized as a stacked panel file (monhtly data) and I have about 6 variables in the file which should all have numeric datatypes. But somehow, Eviews incorrectly recognizes two of the variables as characters even though they're exactely the same as the other 4. I have also made sure in Excel that they all have numeric cell format, but this doesn't help.
Do you have any idea why Eviews is not importing these two variables correctly? I have many NA in the file, as it's unbalanced. But this is also the case for the 4 variables that are correctly recognized.
Your help is highly appreciated!