Page 1 of 1

EViews won't read full time series in my CSV file

Posted: Fri Nov 25, 2016 10:18 am
by chester
I'm trying to import my CSV file into an EViews workfile. It is an annual time series that goes from 1971 to 2015 but for some reason, EViews only reads until 2012 in the workfile. I've uploaded my file. Is there any reason why this would be happening?
newdata.csv
(15.97 KiB) Downloaded 447 times
This is my pageload command:

Code: Select all

pageload "P:\Knowledge\Data Resources\Databases\Scraper\newdata.csv" ftype=ascii rectype=crlf skip=0 fieldtype=delimited delim=comma byrow colhead=2 namepos=first eoltype=pad badfield=NA @freq {%frequency} @smpl @all

Re: EViews won't read full time series in my CSV file

Posted: Sat Nov 26, 2016 1:50 am
by EViews Gareth
Something weird with the format that EViews doesn't like. Re-saving it as xlsx seems to work.

Re: EViews won't read full time series in my CSV file

Posted: Mon Nov 28, 2016 7:46 am
by chester
Alright, thanks for the reply.
In general, are .xlsx files less problematic than .csv files for minor issues like this?

Re: EViews won't read full time series in my CSV file

Posted: Mon Nov 28, 2016 8:40 am
by EViews Gareth
Yes.