SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 20997: The SAS/ACCESS® Interface to PC files on UNIX cannot read Excel column names that contain Asian phonetic text strings

DetailsHotfixAboutRate It
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

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