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.
Try PROC IMPORT as described here:
Import is working. But I feel it works more like input, create new dataset. Not like libname create a link to file.
How did you try and 'read' the file. Did that generate an error? Include your code and log.
Did you try accessing the data with a data step? Post that code
No, I can't. After I use libname, there have libref created, but it empty, there is no data.
How do you know it's empty?
Did you try a data step?
Data want;
set libname.'Sheet1$'n;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.