SUPPORT / SAMPLES & SAS NOTES
 

Support

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

DetailsHotfixAboutRate It

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

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to PC Files64-bit Enabled AIX9.1 TS1M3 SP4
64-bit Enabled HP-UX9.1 TS1M3 SP4
64-bit Enabled Solaris9.1 TS1M3 SP4
HP-UX IPF9.1 TS1M3 SP4
Linux9.1 TS1M3 SP4
Linux on Itanium9.1 TS1M3 SP4
Tru64 UNIX9.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.