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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: