2 questions on the import statement

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt

AnnH
Posts: 22
Joined: Fri Mar 09, 2012 11:42 am

2 questions on the import statement

Postby AnnH » Wed Aug 21, 2013 12:36 pm

If I am importing excel data, how do I include in the import statement that there are 7 header lines?
Also, if my excel files does not have variable names in the header can I include the list of variables in order in the import statement?

right now I have:

import(type=excel) "H:\model\Data\inputs1.xls" @freq q 1956

which sort of works, but it reads in all the header lines together as the variable names.

I tried looking in the command and programming reference but couldn't figure out how to do it.

Thank you.

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

Re: 2 questions on the import statement

Postby EViews Gareth » Wed Aug 21, 2013 2:29 pm

Code: Select all

import(type=excel) "h:\model\data\inputs1.xls" colhead=7 namepos=none names=("name1", "name2", "name3") @freq q 1956
Follow us on Twitter @IHSEViews

AnnH
Posts: 22
Joined: Fri Mar 09, 2012 11:42 am

Re: 2 questions on the import statement

Postby AnnH » Thu Aug 22, 2013 8:05 am

Thank You!!

One more thing - what if I wanted to start reading in data with the fourth column?

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

Re: 2 questions on the import statement

Postby EViews Gareth » Thu Aug 22, 2013 8:08 am

Code: Select all

import(type=excel) "h:\model\data\inputs1.xls" Range="D1" colhead=7 namepos=none names=("name1", "name2", "name3") @freq q 1956
Follow us on Twitter @IHSEViews


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 39 guests