LIBNAME Statement: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows |
Specifies whether to rename columns automatically when they contain
disallowed characters.
Valid in: |
DATA and PROC steps
|
Default value: |
LIBNAME option setting
|
- DBMS
-
specifies that disallowed characters are converted to underscores.
- SAS
-
specifies that columns that contain disallowed characters
are converted into valid SAS variable names, using the format _COLn, where n is the column number
(starting with zero). If a name is converted to a name that already exists,
a sequence number is appended to the end of the new name.
SAS retains column names when reading data, unless a column
name contains characters that SAS does not allow, such as $ or @. SAS allows
alphanumeric characters and the underscore (_).
This option is intended primarily for National Language Support, notably
the conversion of kanji to English characters. English characters that are
converted from kanji are often not allowed in SAS. If you specify DBGEN_NAME=SAS,
a column named DEPT$AMT is renamed to _COLn. n is the column number. If you specify DBGEN_NAME=DBMS, the
DEPT$AMT column is renamed to DEPT_AMT.
To assign this option to a group of tables, use the DBGEN_NAME= option
specified in LIBNAME Options.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.