PROC IMPORT DATAFILE= "C:\Users\x\Proj\Data\A Information Resource.xlsb"
OUT= WORK.ALLTRACTS
DBMS=Excel REPLACE;
/*GETNAMES=YES;*/
SHEET = "1)LICs";
RUN;
Hi there,
I'm trying to import an XLSB file using SAS 9.4. My code is posted above but the system gave the error:
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
ERROR: Connection Failed. See log for details.
Can anyone help?
Thanks!
This question was already solved in this forum:
https://communities.sas.com/t5/SAS-Enterprise-Guide/Import-xlsb-SAS-EG-7-1-64-bits/td-p/351501
Yes, looks like you have the 32-bit Excel to 64-bit SAS problem. The 64-bit ACE engine, a free download from Microsoft, is the solution. Note this only works if your SAS is running on Windows, which it looks like it is.
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 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.