2 questions on the import statement
Posted: 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.
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.