SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 30727: Using multi-byte characters as delimiters is not supported in DBCS or Unicode SAS®

DetailsAboutRate It

SAS supports single-byte characters as delimiters. This is true for double-byte character set (DBCS) environments. Examples of these environments include SAS 9 (Japanese) or Unicode server with SAS 9 (English with DBCS and Unicode Support) with the ENCODING system option set to UTF-8).

For example, the character þ (Latin small-letter thorn) is represented in UTF-8 as two bytes (0xC39E) and in SAS 9 (English with DBCS and Unicode Support). This character is not eligible to use in the DELIMITER= (or DLM=) argument on the INFILE statement or as a delimiter during PROC IMPORT.

To work around this issue, replace the multi-byte character with a single-byte character. For example, replace the string "þ" with the single-byte comma character ",".



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SASMicrosoft® Windows® for 64-Bit Itanium-based Systems9.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter 64-bit Edition9.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise 64-bit Edition9.1 TS1M3 SP4
Microsoft Windows XP 64-bit Edition9.1 TS1M3 SP4
Microsoft® Windows® for x649.1 TS1M3 SP4
Microsoft Windows 2000 Advanced Server9.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server9.1 TS1M3 SP4
Microsoft Windows 2000 Server9.1 TS1M3 SP4
Microsoft Windows 2000 Professional9.1 TS1M3 SP4
Microsoft Windows NT Workstation9.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition9.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition9.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition9.1 TS1M3 SP4
Microsoft Windows XP Professional9.1 TS1M3 SP4
Windows Vista9.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.