I have to give it a try. WOW G. I know what is going on . You must misspell the path name or filename . When I fix path name from /folders/myfolder/x.xlsx ---> /folders/myfolderS/x.xlsx I get the result . But when I use WRONG path name ,SAS still show Libname has been assign successfully.It is so weird. That might be a BUG for SAS. Code: Program libname X XLSX '/folders/myfolders/x.xlsx' ; proc sql; select nliteral(memname) from dictionary.members where libname='X' ; quit; Log: Program Notes (2) 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 53 54 libname X XLSX '/folders/myfolders/x.xlsx' ; NOTE: Libref X was successfully assigned as follows: Engine: XLSX Physical Name: /folders/myfolders/x.xlsx 55 proc sql; 56 select nliteral(memname) 57 from dictionary.members 58 where libname='X' ; 59 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.05 seconds cpu time 0.03 seconds 60 61 62 63 64 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 74 Results: Program SHEET1 SHEET2 SHEET3 And remove $ from your table name ,that could work. 60 data data1; 61 set x.'Sheet1'n; 62 run; NOTE: The import data set has 1 observations and 2 variables. NOTE: There were 1 observations read from the data set X.Sheet1. NOTE: The data set WORK.DATA1 has 1 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds Xia Keshan Message was edited by: xia keshan Message was edited by: xia keshan
... View more