Date:         Wed, 12 Nov 1997 10:37:18 -0500
Reply-To:     "Boyle-Whitesel, Madeline" <MWhitesel@CAROLINAS.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Boyle-Whitesel, Madeline" <MWhitesel@CAROLINAS.ORG>
Subject:      SAS Export Wizard Problems
Content-Type: text/plain; charset="ISO-8859-1"

I was trying to export a compressed SAS data set to an Excel file using
the SAS Export Wizard and I received the following Error in the Log:
 
 
ERROR: Unexpected OLE2 file manipulation error (-2147286928).
ERROR: Insert failed for obs number 116.
 
 
NOTE: Load completed. Examine statistics below.
NOTE:  Inserted (115) obs into s9409.xls.
NOTE:  Rejected (1) insert attempts see the log for details.
 
 
ERROR: Export unsuccessful.  See SAS Log for details.
 
 
When I tried to print the database I received the following note in the
log window, which I have never seen before.
 
 
18   proc print data=mjb.scnc9409;
19   run;
 
NOTE: Access by observation number not available.
      Observation numbers will be counted by PROC PRINT.
NOTE: The PROCEDURE PRINT used 3.02 seconds.
 
 
Has anyone seen these errors before?  What do they mean and are they
related?  I was assuming that they might be related, and that's why I
can't export the SAS data set.  I did try to "set" the original data set
to another one ("try") that was not compressed and export that data set,
but I received the same errors.  I was, however, able to use DBMS/COPY
to transfer the copy of the original SAS data set ("try") to Excel, but
this is not available to everyone in our department.
 
Thanks in advance for any helpful hints on how to resolve or get around
this problem.
 
Madeline
 
________________________________________________________________
 
Madeline J. Boyle-Whitesel
Biostatistician
Carolinas Medical Center
704-355-4159
704-355-1880 (fax)
mwhitesel@carolinas.org
 
"Statistics means never having to say you are certain"
________________________________________________________________