10-19-2014 06:59 PM
can anyone help me with this error.
Am I doing something wrong in the code?????
libname test "C:\Data\Projects\jan_2014_fresh";
%let start =01SEP2014;
%let end =30SEP2014;
%let month =SEP2014;
274 proc export data=final
276 dbms=excel replace;
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
Connection Failed. See log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.25 seconds
user cpu time 0.07 seconds
system cpu time 0.04 seconds
OS Memory 17136.00k
Timestamp 10/19/2014 05:54:33 PM
Step Count 53 Switch Count 0
11-14-2014 06:59 PM
I checked around the SAS communities and was diverted by other responses discussing 64 bit windows. The Class not registered error message from SAS is misleading. The actual cause appears to be some other cause.
I would need to research this further to replicate the error (basically, disconnect my P: drive, which I don't want to do right now.)
If you are one of those users who migrated to 64 bit windows, then yes, you probably should check those other posts mentioning 64 bit.
11-17-2014 07:34 PM
Update: I wasn't sure what was causing my problem so I wrote to SAS support. Here is their answer, which ended up fixing my problem:
It looks as if you are running 32 bit SAS. Since the bits of SAS match, you should be able to use the EXCEL engine to export.
I think your Microsoft Office components need to be reregistered. Please download and install the 32 bit file, AccessDatabaseEngine.exe, from the following link.