I have an Excel 2010 macro file that I want to import into SAS 9.3, 32bit. I want to avoid having to rename the varible name F1 F2 F3...is there a way to import the excel sheet at line 5 is the varible names and at line 6 data starts. Is there a way to specify datarow or namerow in the following SQL? Proc import did not work to avoid F1 F2 F3...?
Varible name starts at line 5
Data Starts at line 6
CONNECT TO EXCEL (PATH="C:\SAS\Programs\EaxceltoSAS\filename.XLSM" );
create table Temp as SELECT * FROM CONNECTION TO EXCEL