When you use SAS/ACCESS Interface to PC Files 9.1.3 in the UNIX environment to pull data from an Excel workbook that resides locally under UNIX, string formulas in the spreadsheet will cause missing values to be read into SAS.

This problem does not occur if the Excel workbook resides on a PC and you use SAS/ACCESS Interface to PC Files 9.1.3 under UNIX with the PC Files Server. The problem also does not occur when you use the IMPORT procedure with SAS/ACCESS Interface to PC Files 9.1.3.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS/ACCESS Interface to PC Files	Tru64 UNIX	9.1 TS1M3 SP4
		Linux on Itanium	9.1 TS1M3 SP4
		Linux	9.1 TS1M3 SP4
		HP-UX IPF	9.1 TS1M3 SP4
		64-bit Enabled Solaris	9.1 TS1M3 SP4
		64-bit Enabled HP-UX	9.1 TS1M3 SP4
		64-bit Enabled AIX	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.

---

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#030657

---

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#030657

---

When you use SAS/ACCESS Interface to PC Files 9.1.3 in the UNIX environment to pull data from an Excel workbook that resides locally under UNIX, string formulas in the spreadsheet will cause missing values to be read into SAS.

Type:	Usage Note
Priority:

Date Modified:	2008-02-22 09:14:15
Date Created:	2007-11-30 09:56:17