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.
2 questions on the import statement
Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13309
- Joined: Tue Sep 16, 2008 5:38 pm
Re: 2 questions on the import statement
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
Re: 2 questions on the import statement
Thank You!!
One more thing - what if I wanted to start reading in data with the fourth column?
One more thing - what if I wanted to start reading in data with the fourth column?
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13309
- Joined: Tue Sep 16, 2008 5:38 pm
Re: 2 questions on the import statement
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
Who is online
Users browsing this forum: No registered users and 39 guests