Page 1 of 1
Importing csv data file to Eviews
Posted: Wed Jul 16, 2014 6:40 am
by 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!
Re: Importing csv data file to Eviews
Posted: Wed Jul 16, 2014 8:38 am
by EViews Gareth
Hard to know without having a copy of the CSV file.
Re: Importing csv data file to Eviews
Posted: Wed Jul 16, 2014 12:20 pm
by VaniaBrahim
Thank you for having a look at it!
Re: Importing csv data file to Eviews
Posted: Wed Jul 16, 2014 12:21 pm
by VaniaBrahim
Strange, it does not upload my file
Re: Importing csv data file to Eviews
Posted: Wed Jul 16, 2014 12:28 pm
by EViews Gareth
You can email it to
support@eviews.com
Re: Importing csv data file to Eviews
Posted: Wed Jul 16, 2014 1:29 pm
by EViews Gareth
Got it, we'll investigate.
Re: Importing csv data file to Eviews
Posted: Thu Jul 17, 2014 1:57 pm
by VaniaBrahim
Hi Gareth,
Do you have any idea what the problem could be?
Re: Importing csv data file to Eviews
Posted: Thu Jul 17, 2014 2:24 pm
by 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
Re: Importing csv data file to Eviews
Posted: Thu Jul 17, 2014 2:37 pm
by 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!