I tried two ways. Using proc import, I can get one sheet if I leave off the sheet=, but with sheet=
I get ERROR: Couldn't find sheet in spreadsheet. So, I don't know how to figure out what SAS thinks the sheet names are.
options validvarname=v7;
FILENAME REFFILE FILESRVC FOLDERPATH='/Users/xxxxxxx' FILENAME='2018_National_Awardees.xlsx';
PROC IMPORT DATAFILE=REFFILE
DBMS=XLSX
OUT=WORK.Awardees_2018;
sheet='2021 Age and Race-Ethnicity';
GETNAMES=YES;
RUN;
Second, I tried this:
libname test XLSX "/Users/xxxxxxx/2018_National_Awardees.xlsx";
And I get
WARNING: No matching members in directory.
... View more