09-23-2016 12:50 PM
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;
Need further help from the community? Please ask a new question.