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!
Importing into transposed data skipping columns
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Posts: 20
- Joined: Tue Feb 10, 2015 10:11 pm
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Importing into transposed data skipping columns
Did you try colhead=3 ?
Follow us on Twitter @IHSEViews
-
- EViews Developer
- Posts: 799
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: Importing into transposed data skipping columns
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.
Who is online
Users browsing this forum: No registered users and 25 guests