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

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

chester
Posts: 44
Joined: Thu May 12, 2016 11:14 am

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

Postby chester » Fri Nov 25, 2016 10:18 am

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

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

Postby EViews Gareth » Sat Nov 26, 2016 1:50 am

Something weird with the format that EViews doesn't like. Re-saving it as xlsx seems to work.

chester
Posts: 44
Joined: Thu May 12, 2016 11:14 am

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

Postby chester » Mon Nov 28, 2016 7:46 am

Alright, thanks for the reply.
In general, are .xlsx files less problematic than .csv files for minor issues like this?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

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

Postby EViews Gareth » Mon Nov 28, 2016 8:40 am

Yes.


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests