Considering second row in excel table as variable names in SAS

[jayakumarmm]

Hi,

I am trying to create a SAS dataset using excel table as a source data. The below code is working if first row in excel table contains field names but I am facing problem for few .xlsx files which contains field names in second row.

I am using excel table import into SAS approach since .xlsm files works fine  instead of Proc import 

libname xlsFile XLSX "/usr/path/Monthly_8.2016.xlsx";
options validvarname=v7;
options SYMBOLGEN MPRINT;

PROC SQL;
    create table  work.raw_data as 
	(select * from xlsFile.'calc result'n);
quit;

[paulkaefer · Accepted solution]

Try specifying the range you import. See the example here.