Problem Note 37485: Updating Microsoft Excel workbooks or adding multiple worksheets creates .bak files replacing Excel worksheets
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
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | |
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | |
| Microsoft® Windows® for x64 | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | |
| Microsoft Windows XP Professional | 9.2 TS2M0 | |
| Windows Vista | 9.2 TS2M0 | |
| 64-bit Enabled AIX | 9.2 TS2M0 | |
| 64-bit Enabled HP-UX | 9.2 TS2M0 | |
| 64-bit Enabled Solaris | 9.2 TS2M0 | |
| HP-UX IPF | 9.2 TS2M0 | |
| Linux | 9.2 TS2M0 | |
| Linux for x64 | 9.2 TS2M0 | |
| Solaris for x64 | 9.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.
A .bak file is created from the original Excel workbook when you update a workbook or add multiple worksheets and you use the SAS® 9.2 XLS engine. The .bak file is not deleted after tne Excel workbook is updated.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2009-10-21 12:21:30 |
| Date Created: | 2009-10-16 12:49:39 |
