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

[mayasak]

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.

[Tom]

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 ....