Considering second row in excel table as variable names in SAS

jayakumarmm — Fri, 23 Sep 2016 16:50:29 GMT

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;

Re: Considering second row in excel table as variable names in SAS

paulkaefer — Fri, 23 Sep 2016 18:13:36 GMT

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

topic Considering second row in excel table as variable names in SAS in SAS Programming

Considering second row in excel table as variable names in SAS

Re: Considering second row in excel table as variable names in SAS