When you import a Microsoft Excel file into SAS Enterprise Guide, an error similar to the following might occur:

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.

This problem can occur when you select Import the data using SAS/ACCESS Interface to PC Files whenever possible on page 4 of 4 of the Import Data Wizard. When you select this option, the import procedure uses the DBMS=Excel option. The DBMS=Excel option requires that both Microsoft Office and SAS are the same bitness (either both 32-bit or both 64-bit). In addition, the procedure includes the GETNAMES= option so that first rows are used as variable names.

For more information, see SAS KB0036453 and SAS Note 41060.