Importing into transposed data skipping columns
Posted: Mon Nov 13, 2017 11:25 pm
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!
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!