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