Import Excel files (64 bit) into SAS (32 bit)

mayasak — Thu, 25 Jan 2024 03:31:58 GMT

Hi,

I'm trying to import several Excel files in a folder (64 bit) into SAS 9.4 (32 bit) and I keep getting these errors:

ERROR: Connect: Class not registered

ERROR: Error in the LIBNAME statement.

ERROR: Connection Failed. See log for details

This is the import statement: libname hou 'C:\Users\260096\Desktop\AB\2020_Datasets'; *set macro parameters; %LET pathway=C:\Users\260096\Desktop\AB\2020_ProcessedDatasets; %LET year=2020;

Installing Excel 32 bit is not feasible so is there workaround way to do it?

Any help is really appreciated.

Re: Import Excel files (64 bit) into SAS (32 bit)

Tom — Thu, 25 Jan 2024 03:49:08 GMT

You did not show any "import" statements. Did some of your code not make it into the post?

Use the XLSX engine and the 32bit vs 64bit does not apply.

/* Using PROC IMPORT */
proc import dbms=xlsx .....

/* or using a LIBREF */
libname old xlsx 'filename.xlsx';
proc copy inlib=old ....

topic Import Excel files (64 bit) into SAS (32 bit) in SAS Programming

Import Excel files (64 bit) into SAS (32 bit)

Re: Import Excel files (64 bit) into SAS (32 bit)