topic Re: Import XLSB file using SAS 9.4 64 bit in SAS Programming

Import XLSB file using SAS 9.4 64 bit

maxjiang6999 — Wed, 02 Oct 2019 00:14:32 GMT

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!

Re: Import XLSB file using SAS 9.4 64 bit

Shmuel — Wed, 02 Oct 2019 00:21:53 GMT

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

Re: Import XLSB file using SAS 9.4 64 bit

SASKiwi — Wed, 02 Oct 2019 01:24:15 GMT

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.