Previous Page | Next Page

LIBNAME Statement: PC Files on Microsoft Windows

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 Value: NONE

Syntax
Syntax Description
Details

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

Previous Page | Next Page | Top of Page