When you export numerous worksheets using the ExcelCS engine, you might receive the following error:

Here is a sample program that replicates the error, depending on the machine used. The error does not occur on all machines.

The problem occurs in various points of the loop, depending on the PC resources and the hard-drive configuration.

To circumvent the problem, do one of the following:

• If SAS^® and the SAS PC Files Server are on the same machine, you can remove the SERVER= and PORT= parameters. Then, the SAS PC Files Server runs as a named pipe rather than a service and resets each time.
• If you are running SAS^® 9.3 TS1M2 or later, you can use DBMS=XLSX instead of DBMS=EXCELCS and remove the SERVER= and PORT= parameters.
• If the first two options are not available, you can add a sleep function as shown here:
  
  %macro test (num) ; %do i = 1 %to &num ; proc export data=sashelp.prdsale outfile="c:\temp\fiddled.xlsx" dbms=excelcs replace; sheet="Sheet&i"; server=myserver; port=9621 ; run; data _null_; x=sleep(1); run; %end ; %mend ; %test(500)

Operating System and Release Information