BookmarkSubscribeRSS Feed
BJH_MICH
Calcite | Level 5

Have a PROC IMPORT that was running fine until I updated to OFFICE 2016 (from OFFICE 2010)...

I have confirmed that BOTH SAS (9.3) and my OFFICE 2016 are BOTH 32 - bit.

 

proc import file=specs out=formats dbms=excel replace;

range='formats';

getnames=yes;

scantext=yes;

run;

 

Now I am getting this error....Googling this problem people mention it occurs when you have different "bit" for SAS versus OFFICE...but both mine are 32 - bit...

Any other ideas?

 

ERROR: Connect: Class not registered

ERROR: Error in the LIBNAME statement.

 

 

1 REPLY 1
Reeza
Super User

Weird. Nothing else changed?

It's possible a driver was accidentally deleted somehow. 

 

 

proc setinit;run;*what is licensed;

proc product_status;run; *what is installed;

 


@BJH_MICH wrote:

Have a PROC IMPORT that was running fine until I updated to OFFICE 2016 (from OFFICE 2010)...

I have confirmed that BOTH SAS (9.3) and my OFFICE 2016 are BOTH 32 - bit.

 

proc import file=specs out=formats dbms=excel replace;

range='formats';

getnames=yes;

scantext=yes;

run;

 

Now I am getting this error....Googling this problem people mention it occurs when you have different "bit" for SAS versus OFFICE...but both mine are 32 - bit...

Any other ideas?

 

ERROR: Connect: Class not registered

ERROR: Error in the LIBNAME statement.

 

 


 

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 725 views
  • 0 likes
  • 2 in conversation