Usage Note 30961: When using SAS/ACCESS® Interface to PC Files on UNIX platforms to write to Excel, some types of data result in a corrupted XLS file
When using the EXPORT procedure with SAS/ACCESS Interface to PC Files on UNIX platforms to write to
spreadsheets in locally-residing (on UNIX) Excel workbooks, certain types of data can result
in a corrupted XLS file.
There is nothing in the SAS log which would indicate that a problem has occurred with the PROC
EXPORT. The problem only becomes apparent when you use Excel to view the spreadsheets. When
you try to view the workbook in Excel, the following message appears:
The document is corrupt and cannot be opened.
This problem does not occur when using SAS/ACCESS Interface to PC Files on UNIX platforms with DBMS=EXCELCS in conjunction with the PC Files Server component to write to Excel workbooks which reside on the PC.
A DEFECT has been opened for this issue. Continue to track such issues.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to PC Files | 64-bit Enabled AIX | 9.1 TS1M3 SP4 | |
64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | |
64-bit Enabled Solaris | 9.1 TS1M3 SP4 | |
HP-UX IPF | 9.1 TS1M3 SP4 | |
Linux | 9.1 TS1M3 SP4 | |
Linux on Itanium | 9.1 TS1M3 SP4 | |
Tru64 UNIX | 9.1 TS1M3 SP4 | |
*
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.
When using SAS/ACCESS Interface to PC Files on UNIX platforms with DBMS=XLS to write to locally-residing (on UNIX) Excel workbooks, certain types of data result in a corrupted XLS file.
Date Modified: | 2008-02-22 09:16:11 |
Date Created: | 2008-01-17 17:45:47 |