SQL connect to Excel 2010 or Proc Import varible names at line 5 and data starts at line 6

Geeman — Thu, 05 Nov 2015 18:45:39 GMT

Hi SASers,

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

PROC SQL ;

CONNECT TO EXCEL (PATH="C:\SAS\Programs\EaxceltoSAS\filename.XLSM" );

create table Temp as SELECT * FROM CONNECTION TO EXCEL

(SELECT * FROM [sheet2$]) ;

DISCONNECT FROM EXCEL;

QUIT;

Re: SQL connect to Excel 2010 or Proc Import varible names at line 5 and data starts at line 6

Reeza — Thu, 05 Nov 2015 19:18:12 GMT

You can try specifying the RANGE to include the titles and the data in a PROC IMPORT

This user had a similar question.

https://communities.sas.com/t5/SAS-Procedures/Proc-Import-Excel/td-p/51087

topic SQL connect to Excel 2010 or Proc Import varible names at line 5 and data starts at line 6 in SAS Procedures

SQL connect to Excel 2010 or Proc Import varible names at line 5 and data starts at line 6

Re: SQL connect to Excel 2010 or Proc Import varible names at line 5 and data starts at line 6