Date: Wed, 1 Apr 2009 22:04:43 -0500
Reply-To: "./ ADD NAME=Data _null_;" <iebupdte@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "./ ADD NAME=Data _null_;" <iebupdte@GMAIL.COM>
Subject: Re: EXCEL libname engine update existing sheet.
Content-Type: text/plain; charset=ISO-8859-1
I am referring to the excel libname engine, not DDE or PROC EXPORT. I
to added data to and existing sheet. SQL INSERT will do that and PROC
I tried MODIFY as in
if 0 then modify xl.'sheet1$'n;
That does not work because modify requires random access exgine the
EXCEL engine does not support that. I am happy with APPEND or SQL I
just wondered if there is another option.
On 4/1/09, Arthur Tabachneck <email@example.com> wrote:
> There's always DDE to a specific range.
> On Wed, 1 Apr 2009 13:51:11 -0500, ./ ADD NAME=Data _null_;
> <iebupdte@GMAIL.COM> wrote:
> >PROC APPEND.
> >Any others?
> >On 4/1/09, ./ ADD NAME=Data _null_; <firstname.lastname@example.org> wrote:
> >> What SAS statements can I use to write observations to and existing
> >> sheet. e.g. ex.'Sheet1$'n.
> >> I can use SQL; INSERT INTO but I would like to know other alternatives
> >> if they exist.