Importing .txt from the EUKLEMS database

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

tvonbrasch
Posts: 569
Joined: Fri Apr 15, 2011 5:35 am

Importing .txt from the EUKLEMS database

Postby tvonbrasch » Wed Nov 20, 2013 1:20 pm

Hi

I want to import data from the EUKLEMS database. How can I import the data when it is in .txt format. The file is too big to upload (16 mb), please have a look at it at http://www.euklems.net/, All countries Basic Files.

I tried wfopen(type=txt) "all_countries_09I.txt" delim=comma, but i get an error message telling me that Alpha series truncated to maximum length.


Sincerely
Thomas von Brasch

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

Re: Importing .txt from the EUKLEMS database

Postby EViews Gareth » Wed Nov 20, 2013 2:01 pm

I don't see where to download the file, so can't try it, but changing the maximum size of alpha series might help you. Options->General Options->Series and Alphas->Alpha Series.

tvonbrasch
Posts: 569
Joined: Fri Apr 15, 2011 5:35 am

Re: Importing .txt from the EUKLEMS database

Postby tvonbrasch » Thu Nov 21, 2013 7:17 am

Hi

Here is a zipped version with eu countries.

can you please have a look at it? It seems that everything is imported in the alpha series.
sincerely
Thomas von Brasch
Attachments
aggregates_09I.zip
(1.17 MiB) Downloaded 325 times

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

Re: Importing .txt from the EUKLEMS database

Postby EViews Gareth » Thu Nov 21, 2013 9:20 am

Seems to work just fine for me. I end up with a 3D panel.

tvonbrasch
Posts: 569
Joined: Fri Apr 15, 2011 5:35 am

Re: Importing .txt from the EUKLEMS database

Postby tvonbrasch » Fri Nov 22, 2013 12:41 am

Hi again Gareth, and thanks for your reply. You are right; the file i uploaded gives me a 3d panel. The difference between this file and the other larger file is that each line is separated with a quotation mark. I have made a copy of a portion of this file (gareth.txt) and attached it to this message. My problem is how can I make eviews understand that the quotation marks represents a delimiter ?
Thanks again for looking at this
Thomas
Attachments
gareth.txt
(8.21 KiB) Downloaded 301 times


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests