Page 1 of 1

Importing into transposed data skipping columns

Posted: Mon Nov 13, 2017 11:25 pm
by jacarandas
Hi,

I was reading through http://www.eviews.com/help/helpintro.ht ... mport.html. But I can't figure out how can I import in a dataset that is transposed, but with my variable names only starting in Column C, while actual data starts in Column D.

This is what I have done, which imports in the transposed data, but doesn't give the data series a name, and doesn't skip the first two columns as well. If the imported data doesn't skip the first two columns, it offsets the actual date the data starts in.

import ABC.csv "byrow" @frequency q 2001 @smpl 2001Q1 2010Q4

Is there a function similar to skip or how should I be doing this?

Thanks!

Re: Importing into transposed data skipping columns

Posted: Tue Nov 14, 2017 9:40 am
by EViews Gareth
Did you try colhead=3 ?

Re: Importing into transposed data skipping columns

Posted: Tue Nov 14, 2017 12:57 pm
by EViews Steve
If you use our import wizard, you can select which row is the name, and which row is where the data starts. At the end, you'll see the captured command with all the appropriate options.