In SAS 8.2, using PROC EXPORT to write a SAS data set to an Excel file,
and that Excel file exists, the entire Excel file is replaced when code
similar to this is used:

  PROC EXPORT DATA= WORK.TEST
              OUTFILE= "c:\my documents\mydata.xls"
              DBMS=EXCEL2000 REPLACE;
  RUN;


Beginning with SAS 9.0, the Export Procedure supports writing to a
specific worksheet in an existing Excel workbook file using the
following code:

  PROC EXPORT DATA= SASHELP.Class
              OUTFILE= "C:\export class.xls"
              DBMS=EXCEL REPLACE;
              SHEET="class";
  RUN;


The following processing will take place in SAS 9.0:

  1 - If the worksheet 'class' exists, only that worksheet in the Excel
      workbook file will be replaced.

  2 - If the worksheet 'class' does not exist, it will be added to the
      Excel workbook.


The remainder of the workbook file (C:\export class.xls)
will not be changed.

Operating System and Release Information