can't get data from Excel file

[KK_QQ]

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. 

[SASKiwi]

Try PROC IMPORT as described here:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-Import-an-Excel-File-to-SAS-University...

[KK_QQ]

Import is working. But I feel it works more like input, create new dataset. Not like libname create a link to file. 

[KK_QQ]

Sorry, I mean infile

[Reeza]

How did you try and 'read' the file. Did that generate an error? Include your code and log. 

[KK_QQ]

 libname prod xlsx "/folders/myfolders/SAS/book1.xlsx";

Log

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

55

56 libname prod xlsx "/folders/myfolders/SAS/book1.xlsx";

NOTE: Libref PROD was successfully assigned as follows:

Engine: XLSX

Physical Name: /folders/myfolders/SAS/book1.xlsx

57

58 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

70

[Reeza]

Did you try accessing the data with a data step? Post that code

[KK_QQ]

No, I can't. After I use libname, there have libref created, but it empty, there is no data.

[Reeza]

How do you know it's empty? 

Did you try a data step? 

Data want;

set libname.'Sheet1$'n;

run;