Importing csv data file to Eviews

[VaniaBrahim]

I am writing my thesis and use a large data set (2.27 million datapoints). For some reason Eviews eliminates variable-values and replaces this with NA. It imports the names of the companies, but all other variables are replaced with NAs. It only does this for 2000 or so datapoints. But because of that, Eviews can't read my dataset as panel because the year identifier is also replaced with NAs.

I hope you guys can help me out, thanks in advance!

[EViews Gareth]

Hard to know without having a copy of the CSV file.

[VaniaBrahim]

Thank you for having a look at it!

[VaniaBrahim]

Strange, it does not upload my file

[EViews Gareth]

You can email it to support@eviews.com

[EViews Gareth]

Got it, we'll investigate.

[VaniaBrahim]

Hi Gareth,

Do you have any idea what the problem could be?

[EViews Gareth]

The mixture of double and single quotes in some of the columns are messing things up for the automatic detection routines. Unfortunately there is a bug in the csv read dialog right now that prevents you from specifying the options manually.

However you can create an EViews program that will open it properly:

Code: Select all

wfopen scriptie_eindbestand1.csv quotes=double

[VaniaBrahim]

Ha, that could make sense. I'll replace the company names with numbers. Ill try the code as soon as I have access to Eviews.

Thank you for your time spent on the file!