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