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.
Product Family | Product | System | SAS Release | |
Reported | Fixed* | |||
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 |