Date: Tue, 29 Sep 2009 19:32:22 +0000
Reply-To: zrab123@COMCAST.NET
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Ken Barz <zrab123@COMCAST.NET>
Subject: Re: Proc Export Oddity
In-Reply-To: <ce1fb7450909291207t38c7e0fbq7473444b94f65f5a@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Yep, that nails it. The dataset name is a valid cell reference. I knew there were more reasons to generally avoid Excel.
Thanks!
----- Original Message -----
From: "Data _null_;" <iebupdte@gmail.com>
To: zrab123@comcast.net
Cc: SAS-L@listserv.uga.edu
Sent: Tuesday, September 29, 2009 1:07:42 PM GMT -07:00 US/Canada Mountain
Subject: Re: Proc Export Oddity
AE2 looks like a cell reference.
http://support.sas.com/kb/14/475.html
I think explains the behavior, but not how to fix it.
On 9/29/09, Ken Barz <zrab123@comcast.net> wrote:
> If I delete and rerun, it works fine. Then if I immediately rerun without opening anything, it bombs on just that workbook. If I close SAS, reopen and run it bombs (whether or not I've tried the first immediate rerun) it bombs. I've confirmed the workbook is not open, there's nothing in task manager, and I'm the only one with access to the folder. This produces a total of 24 workbooks and only the one causes any problem. It's also the only one with a number in the dataset name curiously.
>
> This is SAS 9.2, 32 bit.
>
> ----- Original Message -----
> From: "Joe Matise" <snoopy369@gmail.com>
> To: zrab123@comcast.net
> Cc: SAS-L@listserv.uga.edu
> Sent: Tuesday, September 29, 2009 10:58:58 AM GMT -07:00 US/Canada Mountain
> Subject: Re: Proc Export Oddity
>
> Does it reoccur if you delete the sheet (in Windows) and rerun? Also, close SAS, while you're at it...
>
> What version of SAS?
>
> -Joe
>
>
> On Tue, Sep 29, 2009 at 11:36 AM, Ken Barz < zrab123@comcast.net > wrote:
>
>
> I'm running the following to output a series of Excel spreadsheets with meta about SAS datasets:
>
> proc export data= &ds
> outfile= "&dataout.\&ds..XLS"
> dbms=excel label replace;
> sheet="&ds";
> run;
>
> For all datasets except one it works fine both on the first run and any subsequent. However, for dataset AE2, for some reason the sheet name comes out as _AE2, and when I try a subsequent run to replace the original, I get:
>
>
> ERROR: The MS Excel table AE2 has been opened for OUTPUT. This table already exists, or there is a name conflict with an
> existing object. This table will not be replaced. This engine does not support the REPLACE option.
> ERROR: Export unsuccessful. See SAS Log for details.
>
> Well, it's not open and the only difference I see is the underscore in the sheet name. Any idea on why it's giving me the underscore and why it bombs on just the one spreadsheet?
> Thanks
>
| 
