| 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 |
|---|
|
| 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
|
