Problem Note 20997: The SAS/ACCESS® Interface to PC files on UNIX cannot read Excel column names that contain Asian phonetic text strings
The SAS/ACCESS interface to PC files on UNIX does not surface data from
an Excel spreadsheet which has column names that contain Asian phonetic
text strings.
If the spreadsheet is saved locally on the UNIX box and accessed
with the IMPORT procedure using DBMS=XLS, the code fails and returns a
segmentation violation similar to the following:
Segmentation Violation In Task [ IMPORT ]
Fault Occurred at
[/TECH/SP/SOL2_913BISP4/SAS_9.1/sasexe/sasimxcl:dindbssetup+0x345c]
Task Traceback
If the Excel spreadsheet is saved on a Windows PC and is accessed by
PROC IMPORT to the PC FILES SERVER component, the code also fails,
but with an error similar to the following:
ERROR: CLI open cursor error: [Microsoft][ODBC Excel Driver] Selected
collating sequence not
supported by the operating system.
ERROR: Import unsuccessful. See SAS Log for details.
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 | Solaris for x64 | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
64-bit Enabled Solaris | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
Linux | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
Linux on Itanium | 9.1 TS1M3 SP4 | |
HP-UX IPF | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
Tru64 UNIX | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
64-bit Enabled AIX | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
*
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.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2007-09-21 13:36:33 |
Date Created: | 2007-09-21 11:25:46 |