I was able to create a libname but get errors with my proc contents step (note: my worksheets within my animal data workbook are named as "2014 Counties"): options validvarname=v7; libname mydata xlsx "/folders/myfolders/sasuser.v94/animaldata.xlsx"; proc contents data=mydata.2014 counties; run; Errors: ERROR: Couldn't find range or sheet in spreadsheet ERROR: File MYDATA.'2014'n.DATA does not exist. ERROR 22-322: Syntax error, expecting one of the following: ;, (, CENTILES, DATA, DETAILS, DIR, DIRECTORY, FMTLEN, LIB, MEMTYPE, MT, MTYPE, NODETAILS, NODS, NOPRINT, ORDER, OUT, OUT2, SHORT, VARNUM. ERROR 202-322: The option or parameter is not recognized and will be ignored.
... View more