Hi,
I am tryin to import an Excel file that has three sheets, but when I try to use a libname statement to access the sheet names, it only seems to pick up 2 sheets. Does anyone have experience with this and can tell me what the issue might be?
The code I'm using is:
libname xl "C:\....\Sample File.xls";
Thanks a lot
Please show the names of the sheets in the Excel file.
For example, the sheet names are:
1) Cash and Liquidity Cushion Mgt
2) Cash Movement Summary
3) Fees & Misc.
I have a few hundred Excel files with varying numbers of sheets, but the first sheet ("Cash and Liquidity Cushion Mgt") is never identified. I tried renaming or re-ordering but to no avail.
Then it's something in the sheet.
How does this one differ from the others?
Copy the workbook and delete sections of the sheet at time (binary search) until you narrow it down.
The sheet name is too long. Try making them shorter.
PG
It's only 30 chars?
Excel sheets can have blanks that aren't seen unless you highlight the name like preparing to rename. And even then depending on the font may not be noticeable. I was suspecting long names which is why I asked earlier.
Actually you can still read table xl.'Cash and Liquidity Cushion Mgt$'n but you can't see it in SAS Explorer window.
PG
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.