EViews.com

Hi All,

I am still using EViews 8.1 and I have this question I don't seem to have a way to solve.

I wrote a program that sucks in csv files (panel datasets with date id and cross id columns) into eviews, convert them into dated panel using pagestruct, but before I could do anything, I found out that the supposedly string cross id column has been converted into series by Eviews.

I understand that it's because I have a mixture of double quoted numerics and characters, and the latter don't appear until the end of the dataset.

I read the wfopen help page carefully, and saw that there is a quotes=double for html files, but I can't seem to make it work for csv's. The other way I see is to predefine the column type (using format=(A3), for instance), but I have csv files with different number of columns (more than 50+ files) and I can't predefine them all before I imported them.

Is there a way to solve this?

Thanks.

Tchaithonov

You can try using the scan=all argument.

Hi Gareth,

Thanks for the suggestion, but it doesn't seem to work.

I tried this: it seems gives me a series for that column with NAs replacing all the characters.

Am I doing anything wrong with that code? Please let me know. Thanks.

Philip

It is an argument not an option

http://www.eviews.com/help/helpintro.ht ... 3ww2481164

Yeah, I actually tried both ways
Not working.

We'd need to see the file.