topic Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file in SAS Programming

SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

KendallM — Mon, 22 Feb 2016 22:05:05 GMT

Hello,

I've gone through several pages of google searches and the only topic that comes up about this is that it won't work if SAS and Excel are different bit versions. Both of mine are x64, and I had no issues until "upgrading" to Office 2013 (x64). I'd prefer to not go the PCFiles route. Has anyone found a reason why 9.4 and Office 2013 will not play nice?

My code:

%let path=...\CR\;

/* Setting Thesis library to store data sets */
libname CR "...\CR\SAS";
libname PageL excel "&path\Arizona\Keep_tabs_Page_level_Arizona_January.xls";
libname PostL excel "&path\Arizona\Keep_tabs_Post_level_Arizona_January.xls";

Log output:

121 %let path=C:\Users\Symtrips\Google Drive\Jobs\CR\;
122
123 /* Setting library to store data sets */
124 libname CR "...\CR\SAS";
NOTE: Libref CR was successfully assigned as follows:
Engine: V9
Physical Name: ...\CR\SAS
125 libname PageL excel "&path\Arizona\Keep_tabs_Page_level_Arizona_January.xls";
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
126 libname PostL excel "&path\Arizona\Keep_tabs_Post_level_Arizona_January.xls";
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.

Thank you in advance! Again both programs are running the same bit version (x64)

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

Ksharp — Tue, 23 Feb 2016 01:32:10 GMT

Did you try XLSX , XLS engine ?

libname PostL XLSX "&path\Arizona\Keep_tabs_Post_level_Arizona_January.xls";

libname PostL XLS "&path\Arizona\Keep_tabs_Post_level_Arizona_January.xls";

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

KendallM — Tue, 23 Feb 2016 21:17:24 GMT

I was able to work around by saving the file as an .xls and not specifying any engine.

"libname PageL "&path\... etc.xls" and it read in with no errors.

Still not sure what the issue is with Office 2013 and SAS 9.4.

As a note I was able to also use the "excel" engine after resaving the files as .xls and recieved no errors.

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

SASKiwi — Wed, 24 Feb 2016 01:09:53 GMT

What format were the files in originally if saving as XLS fixes the problem?

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

KendallM — Wed, 24 Feb 2016 18:07:26 GMT

The files had originally been saved as *.xlsx workbooks, but re-saving them as excel 97-2003 *.xls workbooks allowed SAS 9.4 to import them without error.

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

SASKiwi — Wed, 24 Feb 2016 19:08:00 GMT

We use SAS 9.4 and Office 2010 without problems, but I guess you did as well until upgrading to 2013. I'm assuming here you are using SAS running locally on a PC not on a server?

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

KendallM — Wed, 24 Feb 2016 20:09:30 GMT

Correct, no issues until upgrading from Office 2010 to 2013. SAS is running locally. Funnily enough my thesis spreadsheets are .xlsx but I haven't touched them since before the Office upgrade, those code files still function perfectly. Must be a header change in the 2013 file formatting causing SAS not to recognize it correctly. I also noticed that when using PCFiles, it will "import" the data from the newer .xlsx files but it doesn't actually read in correctly. Comes out with some garbage and corruption.

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

lindseyb — Tue, 28 Feb 2017 00:38:18 GMT

Hi,

Were you ever able to get your code to work using the excel or xlsx engine?

Thanks!

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

RXM — Tue, 09 Jul 2019 12:54:12 GMT

I have the same problem. A temporary solution is to export the file as a .csv instead of as Excel. You can always open the .csv file in Excel and save it as whatever Excel version you prefer.

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

Vince_SAS — Tue, 09 Jul 2019 13:20:13 GMT

The "Class not registered" error indicates a bitness mismatch between SAS and the Excel data access libraries on the machine. Using the XLS engine to work with .xls files or the XLSX engine to work with .xlsx files should get around this issue.

Vince DelGobbo

SAS R&D

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

RXM — Tue, 09 Jul 2019 13:28:20 GMT

Vince, thanks. I tried exporting the file as .xls and still got the error, so I went the .csv route.

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

Vince_SAS — Tue, 09 Jul 2019 13:36:45 GMT

Did you explicitly specify DBMS=xls? You should not have gotten the error in that case.

Vince DelGobbo

SAS R&D

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

RXM — Tue, 09 Jul 2019 14:02:38 GMT

Vince,

Thank you! That did it. I still had dbms=EXCEL with the file extension .xls.

Rob

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

PaigeMiller — Mon, 03 Aug 2020 12:05:14 GMT

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
ERROR: Connection Failed.  See log for details.

I have code that we run every month to read .xlsx and .xlsm files with PROC IMPORT and DBMS=EXCEL, and I have never had this particular problem until today. I am not aware of any system changes here, but there's no way I can be sure. Why does this happen, and can I go back to using PROC IMPORT with DBMS=EXCEL so I don't have to change my code? I can read the files correctly with DBMS=XLSX, but the column names change from F1 F2 F3 etc. to A B C etc., meaning I have to change my code.

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

Vince_SAS — Mon, 03 Aug 2020 12:42:24 GMT

It seems likely that something changed on your system.

You should contact your IT department to ensure that the bitness of Microsoft Excel installed on the machine running SAS matches the bitness of SAS on that machine. The problem should go away once that mismatch is fixed.

Another possibility is to install the 32-bit Excel/Office libraries along with the 64-bit libraries. I doubt that this is a "Microsoft supported/suggested" environment but it might work for you. This is also something that you will have to work with your IT department to implement.

You can contact our Technical Support Department if you have questions about these two strategies, or if you have other questions:

https://support.sas.com/en/technical-support/submit-a-support-request.html

Going forward, I would like to suggest using the XLSX engine for all new code, and that you prepare to transition to using XLSX in the older code. If you run SAS on a different machine/server in the future, your working EXCEL engine code might also fail. For example, the EXCEL engine works only on Windows systems, so moving to a UNIX server will also cause your code to fail, but for a different reason.

Vince DelGobbo

SAS R&D

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

PaigeMiller — Mon, 03 Aug 2020 13:06:03 GMT

Thanks @Vince_SAS , I have forwarded your reply to our IT department.

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

jszabo — Tue, 10 Sep 2024 18:03:53 GMT

I go through this every year. Someone else installs office after sas, and the 'Microsoft Access Runtime 2013' gets removed. Reinstalling the engine fixes it.

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

MachelleW — Tue, 18 Mar 2025 20:03:27 GMT

That solution did not work for me.

I still received this error message:

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
NOTE: Attachments for -3 reestablished for new parent.
NOTE: Import Cancelled.

Re: SAS 9.4 x64 Connect: Class not registered importing excel 2013 x64 file

SASKiwi — Sat, 22 Mar 2025 02:20:14 GMT

@MachelleW - Please post your complete SAS log including code and errors. Errors by themselves aren't helpful. Also what OS are you running this on? Windows or Linux? If it is Linux then the only Excel DBMS that will work is XLSX.