SAS export to Excel file issue

runrunbunny — Tue, 05 Jan 2021 02:58:01 GMT

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

Re: SAS export to Excel file issue

AnandVyas — Tue, 05 Jan 2021 03:28:21 GMT

Hi @runrunbunny

Check out this KB link mentioning about similar problem.

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

Re: SAS export to Excel file issue

runrunbunny — Tue, 05 Jan 2021 03:31:02 GMT

Thank you!

topic SAS export to Excel file issue in SAS Programming

SAS export to Excel file issue

Re: SAS export to Excel file issue

Re: SAS export to Excel file issue