01-23-2017 12:12 AM
I am using SAS University Edition. I tried to using below statment to access excel file
libname prod xlsx "/folders/myfolders/SAS/book1.xlsx";
Actually there is no error in log. But I can only see the prod libref is created but there is no way to access the data in the Excel file.
I attach the book1 file, from sheet2 you can see the result from proc contents, there is connection, but can't read data.
01-23-2017 10:59 PM