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.

Become an Explorer! Join SAS Analytics Explorers to learn and complete challenges that earn rewards!

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

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
  • 818 views
  • 4 likes
  • 5 in conversation