series names from data imported from CSV files

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

Macrodata
Posts: 22
Joined: Tue Aug 02, 2011 5:52 pm

series names from data imported from CSV files

Postby Macrodata » Thu Sep 15, 2011 9:52 pm

Hi,

I'm importing data from quite a few different CSV files. Hence I include a line like

import T:\ZAPPS\Eviews\CSV\accom_ann.csv @freq q 1996q3

in programs.

My problem is that sometimes the series titles are read in based on the labels in CSV file and other times (despite labels being present in the CSV file) the series are named series01, series02 etc.

I have attached two csv files.

A program with

import T:\ZAPPS\Eviews\CSV\manqnew1.csv @freq q 1996q3

in it downloads the series with the names in the csv file (with the .'s substitued with _'s as you'd expect)

but

import T:\ZAPPS\Eviews\CSV\accom_ann.csv @freq a 1996

gives me series named series01... etc

Why is this and what can I do to get the series to take the names in the csv file?

I'm using Eviews 7.2 enterprise

thanks
Attachments
Accom_ann.csv
(7.44 KiB) Downloaded 249 times
MANQnew1.csv
(46.85 KiB) Downloaded 280 times

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

Re: series names from data imported from CSV files

Postby EViews Gareth » Fri Sep 16, 2011 7:49 am

The attachments became corrupted somehow. Could you attach them again?

Macrodata
Posts: 22
Joined: Tue Aug 02, 2011 5:52 pm

Re: series names from data imported from CSV files

Postby Macrodata » Sun Sep 18, 2011 1:53 pm

files reattached - if this doesn't work I can email
Attachments
MANQnew1.csv
(46.85 KiB) Downloaded 339 times
Accom_ann.csv
(7.44 KiB) Downloaded 368 times

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

Re: series names from data imported from CSV files

Postby EViews Gareth » Sun Sep 18, 2011 4:32 pm

Force EViews not to skip any header lines:

Code: Select all

import T:\ZAPPS\Eviews\CSV\accom_ann.csv skip=0 @freq q 1996q3

Macrodata
Posts: 22
Joined: Tue Aug 02, 2011 5:52 pm

Re: series names from data imported from CSV files

Postby Macrodata » Sun Sep 18, 2011 9:49 pm

thanks - perfect


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 1 guest