Date:         Fri, 15 Sep 2006 01:51:23 -0700
Reply-To:     Andreww <andrew.whittam@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Andreww <andrew.whittam@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: proc export to xl - error if anything in sheet
Comments: To: sas-l@uga.edu
In-Reply-To:  <200609141644.k8EEk1sU014429@mailgw.cc.uga.edu>
Content-Type: text/plain; charset="iso-8859-1"

Thats what I thought.

The code exports about 20 rows worth of data, I added total for the
numerics and got one of SAS's "encrypted" messages which I can't
recall.

Thanks anyway.

Andrew


"Howard Schreier <hs AT dc-sug DOT org>" wrote:
> On Thu, 14 Sep 2006 04:07:38 -0700, Andreww <andrew.whittam@GMAIL.COM> wrote:
>
> >Hi - Have the following code to export to xl (v97).  If there is
> >anything in the sheet it fails (sorry can't recall error text).
> >
> >proc export data=gen.test
> >        outfile='C:\test.xls
> >        dbms=excel replace;
> >        sheet='data';
> >run;
> >
> >Is there an option/setting which just overwrites what is in the sheet
> >data and therefor the export doesn't fail?
>
> Yes. REPLACE, which you have coded. If I read the documentation correctly,
> its effect is on the sheet as a whole (not a range within).
>
> >
> >Whats in the cells in 'data' sheet is beyond where the data goes!
> >
> >Cheers
> >
> >Andrew