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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.