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.
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.