BookmarkSubscribeRSS Feed
esbabu
Fluorite | Level 6

Hello
Can the xlsx libname engine read ore that 256 rows and 65353 rows?
I have to a large excel file.

4 REPLIES 4
Ksharp
Super User
Yes. I think so.
XLSX engine is designed by SAS.
EXCEL engine is designed by Microsoft.
Since both are the most recent engine, I think you could read in this large excel file.
LinusH
Tourmaline | Level 20
I mean, why don't you just try?
Data never sleeps
ChrisHemedinger
Community Manager

"Try it" is good advice, but in general Yes, it should work. PROC IMPORT with DBMS=XLSX or LIBNAME XLSX both use a direct file reader that complies with the XLSX file format, which supports these larger sheet sizes.

SAS Innovate 2026: Register now! April 27-30 in Grapevine TX -- it's the premier conference for SAS users!

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 698 views
  • 4 likes
  • 5 in conversation