DBENCODING

Specifies the encoding character set to use in the Microsoft Access database or in the Microsoft Excel workbook.
Valid in: DATA and PROC steps.
Default: NONE

Syntax

DBENCODING=12–byte SAS encoding-value

Syntax Description

The 12-byte SAS encoding-value is an encoding value that SAS defines. It can be up to 12 characters long. For a list of valid values, see the section “Encoding Values in SAS Language Elements” in SAS National Language Support Reference Guide.

Details

Specify the encoding character set to use in your Microsoft Access database or Excel workbook file. This option enables SAS to transcode character data between the SAS session encoding and the DBENCODING value.
It is recommended that you use UNICODE=YES instead of DBENCODING. Setting UNICODE=YES is equivalent to setting DBENCODING='UTF-16'.
This enables SAS to bind text in wide character format. SAS is also enabled to transcode data between a SAS session. For example, Chinese BIG5 encoding, and Access or Excel in UNICODE encoding. In a UTF-8 session, SAS assumes that UNICODE=YES.
Transcoding is a process that converts text data from one encoding to another encoding. Note
  • It does not translate from one language to another language.
  • It does not translate the English language to the Japanese language.
  • It does not translate the Chinese language to the Japanese language.
  • It might map some Chinese characters to Japanese Hanzi characters.