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
Does your site license SAS/Access for PC File Formats?
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.
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.
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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: