SAS export to Excel file issue

[runrunbunny]

Hi SAS Users,

I have a problem when exporting a SAS file(235,009 observations) to an Excel file.

The code is:

PROC EXPORT DATA=SASFILE

OUTFILE='P:\OUT\EXCELFILE.xlsx'

DBMS=excel REPLACE;

RUN;

However I got an error in the log:

ERROR: Execute: Unable to insert row

WARNING: File deletion failed for _IMEX_.SASFILE.DATA.

ERROR: Export unsuccessful. See SAS Log for details.

But there has not much information in the log. I checked the output folder(P:\OUT\) and did see the Excel file has been output but not fully output. The input SAS file has 235,009 observations, but the output Excel file only has 212,419 observations. There are 23,590 observations missing! So that's why the log says 'Unable to insert row'.

I have struggled this issue with multiple hours. Could you please give me some advice?

Thank you in advance!

Best,

Runrunbunny

[AnandVyas · Accepted solution]

Hi @runrunbunny 

Check out this KB link mentioning about similar problem.

https://support.sas.com/kb/14/487.html

[runrunbunny]

Thank you!