Importing into transposed data skipping columns

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Jason, EViews Moderator, EViews Pamela

jacarandas
Posts: 20
Joined: Tue Feb 10, 2015 10:11 pm

Importing into transposed data skipping columns

Postby jacarandas » 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!

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11378
Joined: Tue Sep 16, 2008 5:38 pm

Re: Importing into transposed data skipping columns

Postby EViews Gareth » Tue Nov 14, 2017 9:40 am

Did you try colhead=3 ?
Follow us on Twitter @IHSEViews

EViews Steve
EViews Developer
Posts: 443
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: Importing into transposed data skipping columns

Postby EViews Steve » Tue Nov 14, 2017 12:57 pm

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.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 5 guests