BookmarkSubscribeRSS Feed
mayasak
Quartz | Level 8

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.

1 REPLY 1
Tom
Super User Tom
Super User

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

 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 425 views
  • 0 likes
  • 2 in conversation