Page 1 of 1

series names from data imported from CSV files

Posted: Thu Sep 15, 2011 9:52 pm
by Macrodata
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

Re: series names from data imported from CSV files

Posted: Fri Sep 16, 2011 7:49 am
by EViews Gareth
The attachments became corrupted somehow. Could you attach them again?

Re: series names from data imported from CSV files

Posted: Sun Sep 18, 2011 1:53 pm
by Macrodata
files reattached - if this doesn't work I can email

Re: series names from data imported from CSV files

Posted: Sun Sep 18, 2011 4:32 pm
by EViews Gareth
Force EViews not to skip any header lines:

Code: Select all

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

Re: series names from data imported from CSV files

Posted: Sun Sep 18, 2011 9:49 pm
by Macrodata
thanks - perfect