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
Hi @runrunbunny
Check out this KB link mentioning about similar problem.
https://support.sas.com/kb/14/487.html
Hi @runrunbunny
Check out this KB link mentioning about similar problem.
https://support.sas.com/kb/14/487.html
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 25. 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.