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;
Try specifying the range you import. See the example here.
Try specifying the range you import. See the example here.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.