Page 1 of 1

Command line for importing data in rows

Posted: Tue Jan 06, 2009 8:47 pm
by renjinlu
Hi, suppose I have an ASCII file with data in rows, what is the command line to import the data series row by row?

I know how to do this manually, but I am writing a program to import the data.

An imaginery ASCII data set would look like this:

GDP, 1, 3, 5, 7, 9
CONS, 0.5,2,3,5,7
M1,2,3,4,5,6

Thanks!

Re: Command line for importing data in rows

Posted: Wed Jan 07, 2009 9:07 am
by EViews Gareth
You want the READ command with a t option:

read(t) myfile.xls

Re: Command line for importing data in rows, Eviews

Posted: Wed Jan 07, 2009 9:33 am
by renjinlu
Hi, it works. You are great.

Just to help future readers to this forum:

To import "my.csv" with data series in rows, series name in the first column, data file layout rectangular, with 3000 data series, the command line to use is

read(t,rect, name, label=1) my.csv 3000

Thanks a lot!