|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>|
|Subject: ||Re: proc export to xl - error if anything in sheet|
|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
"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';
> >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!