That does not happen for me, so I'm not sure what the difference is.
Perhaps an excel setting?
When I run:
input id var1 var2 var3;
1 0 1 2
2 2 2 2
3 4 4 4
4 4 3 4
proc export data=want file="c:\temp\test.xlsx" replace;
and then open test.xlsx, modify a cell, hit 'save', and close it, there is
no "Backup of test.xlsx" file in that location.
On Wed, Sep 15, 2010 at 11:57 AM, Joe DeShon <
> 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
> end of the program. When I upgraded to 9.2, I changed the ".xls" to
> 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