Append with Export

[Jackie_Stanbank]

hi would like to export a file to a certain sheet in excel, but instead of replacing the data, i would like to append.

how do i do this?

[Bill]

One way would be first import the data into SAS, append the new data to the SAS dataset and then export the new larger SAS dataset to excel - replacing the original excel file.

This does keep the process within the confines of proc import and export.

[SASKiwi]

Try this test:

LIBNAME WrkBk EXCEL "My Workbook.xls" VER=2000;

DATA WrkBk.class;
SET sashelp.class;
RUN;

LIBNAME WrkBk CLEAR;

LIBNAME WrkBk EXCEL "My Workbook.xls" SCAN_TEXT=NO;

PROC APPEND BASE=WrkBk.class
DATA=sashelp.class;
RUN;
LIBNAME WrkBk CLEAR;