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.
Comments: To: Arthur Tabachneck <art297@netscape.net>
In-Reply-To:  <200904012156.n31JuHG9000309@malibu.cc.uga.edu>
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
APPEND.

I tried MODIFY as in

data xl.'sheet1$'n;
   if 0 then modify xl.'sheet1$'n;
   set data;
   output;
   run;

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 <art297@netscape.net> wrote:
> datanull,
>
> There's always DDE to a specific range.
>
> Art
> ---------
> 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_; <iebupdte@gmail.com> 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.
> >>
>