topic Re: ERROR WHILE EXPORTING??? in SAS Programming

ERROR WHILE EXPORTING???

robertrao — Sun, 19 Oct 2014 22:59:33 GMT

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

Re: ERROR WHILE EXPORTING???

art297 — Mon, 20 Oct 2014 00:00:57 GMT

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

Re: ERROR WHILE EXPORTING???

Ksharp — Mon, 20 Oct 2014 12:40:02 GMT

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.

Re: ERROR WHILE EXPORTING???

KentL — Fri, 14 Nov 2014 23:59:12 GMT

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.

Re: ERROR WHILE EXPORTING???

KentL — Tue, 18 Nov 2014 00:34:03 GMT

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!