12-22-2015 11:27 AM
I am using a libname statement to access the different sheets in an .xls workbook. For example,:
libname xls "C:\MyDoc.xls";
However, I noticed that sometimes a sheet with a long sheet name does not appear in my library. Is there a workaround for this apparent character limit?
12-22-2015 11:36 AM
Thanks. Can you illustrate how to do that? Alternatively, is there a way to count the number of sheets in an Excel workbook without extracting the name, even if the sheet name is longer than 32 characters?
12-22-2015 12:02 PM
12-22-2015 01:50 PM
There is no workaround in the current SAS version for displaying sheet/table names longer than 32 characters in SAS library lists. The same problem occurs with accessing databases such as Oracle, SQL Server etc.
The only way to read these is using SQL PASSTHRU where you can specify a sheet name longer than 32 characters.
This is an often-requested enhancement to SAS so I'm hopeful it will happen in a future release.