Date:         Wed, 15 Sep 2010 11:06:27 -0700
Reply-To:     "DUELL, BOB (ATTCINW)" <BD9439@ATT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "DUELL, BOB (ATTCINW)" <BD9439@ATT.COM>
Subject:      Re: Proc Export forces an Excel backup
Comments: To: Joe Matise <snoopy369@GMAIL.COM>
In-Reply-To:  <AANLkTinwVFGHH21HmziMo=Dpf=JMnyrNGKt4jw-CPKPc@mail.gmail.com>
Content-Type: text/plain; charset="US-ASCII"

Actually, if you are using Office 2007 and SAS 9.2, you should see a
file named "c:\Backup of test.xlk" (not ".xlsx".  I have the same
complaint.  This seems to be a new SAS "feature".

I'd also like to know how to turn this off, so I'm looking forward to
some solution.

Bob

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Joe
Matise
Sent: Wednesday, September 15, 2010 10:46 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Proc Export forces an Excel backup

That does not happen for me, so I'm not sure what the difference is.
Perhaps an excel setting?

When I run:

data have;
input id var1 var2 var3;
cards;
1 0 1 2
2 2 2 2
3 4 4 4
4 4 3 4
;
run;

proc export data=want file="c:\temp\test.xlsx" replace;
run;

and then open test.xlsx, modify a cell, hit 'save', and close it, there
is
no "Backup of test.xlsx" file in that location.

-Joe

On Wed, Sep 15, 2010 at 11:57 AM, Joe DeShon <
Joe.DeShon@boehringer-ingelheim.com> wrote:

> I just upgraded from SAS 9.1 to 9.2.  Some of the changes are not as
benign
> as I had hoped.
>
> I have several programs that do a simple proc export to an Excel file
at
> the
> end of the program.  When I upgraded to 9.2, I changed the ".xls" to
> ".xlsx"
> to write an Excel 2007 version.  It seemed to work fine.
>
> But I discovered if the exported file is ever subsequently edited and
saved
> by Excel (a common thing around here), a backup version is
automatically
> created named 'Backup of foo.xlk'.
>
> I learned that when proc export in 9.2 writes a .xlsx file, it turns
on the
> "Always create backup" flag in the output file.  But it doesn't do
that for
> .xls files.
>
> Is there an option to tell proc export NOT to turn on that flag?  (For
that
> matter, why does it do that?)
>
> Joe DeShon
> joe.deshon@boehringer-ingelheim.com
>