ERROR WHILE EXPORTING???

[robertrao]

Hi Team,

can anyone help me with this error.

Am I doing something wrong in the code?????

Thanks

libname test "C:\Data\Projects\jan_2014_fresh";

%let start =01SEP2014;   
%let end =30SEP2014;
%let month =SEP2014;

274  proc export data=final
275  outfile="C:\Data\Projects\jan_2014_fresh\project-&month..xls"
276  dbms=excel replace;
277  sheet=&MONTH._project;
278  run;

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
      memory              295.28k
      OS Memory           17136.00k
      Timestamp           10/19/2014 05:54:33 PM
      Step Count                        53  Switch Count  0

[art297]

Does your site license SAS/Access for PC File Formats?

[Ksharp]

That does say your Office and SAS are not compatible .  in other wise, you either have 64bit SAS and 32bit Office or 32bit SAS and 64bit Office.

[KentL]

Hi All,

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.

[KentL]

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.

http://www.microsoft.com/en-us/download/details.aspx?id=13255

Thanks SAS!