topic Re: Append with Export in SAS Procedures

Append with Export

Jackie_Stanbank — Wed, 07 Jul 2010 12:47:17 GMT

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?

Re: Append with Export

Bill — Wed, 07 Jul 2010 14:24:09 GMT

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.

Re: Append with Export

SASKiwi — Thu, 08 Jul 2010 02:13:49 GMT

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;