SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 37485: Updating Microsoft Excel workbooks or adding multiple worksheets creates .bak files replacing Excel worksheets

DetailsAboutRate It

The SAS® 9.2 XLS engine creates Microsoft Excel .bak files in the same directory as the Excel workbook when you update the workbook or add multiple worksheets. A .bak file is created because a backup copy of the Excel workbook is created before the XLS engine attempts to update the existing Excel workbook. These .bak files are not deleted when the update is made.

This problem occurs in SAS 9.2 (TS2M0) and later because the XLS engine can create multiple worksheets and update worksheets in the same location.

When SAS creates a new workbook with the XLS engine, a .bak file is not created because no backup copy is required.

Currently, there is no solution or workaround for this problem.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to PC FilesMicrosoft® Windows® for 64-Bit Itanium-based Systems9.2 TS2M0
Microsoft Windows Server 2003 Datacenter 64-bit Edition9.2 TS2M0
Microsoft Windows Server 2003 Enterprise 64-bit Edition9.2 TS2M0
Microsoft Windows XP 64-bit Edition9.2 TS2M0
Microsoft® Windows® for x649.2 TS2M0
Microsoft Windows Server 2003 Datacenter Edition9.2 TS2M0
Microsoft Windows Server 2003 Enterprise Edition9.2 TS2M0
Microsoft Windows Server 2003 Standard Edition9.2 TS2M0
Microsoft Windows XP Professional9.2 TS2M0
Windows Vista9.2 TS2M0
64-bit Enabled AIX9.2 TS2M0
64-bit Enabled HP-UX9.2 TS2M0
64-bit Enabled Solaris9.2 TS2M0
HP-UX IPF9.2 TS2M0
Linux9.2 TS2M0
Linux for x649.2 TS2M0
Solaris for x649.2 TS2M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.