Specifies how SAS automatically renames to valid SAS variable names any DBMS columns that contain characters that SAS does not allow.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| CONNECT statement | |
| Category: | Data Set Control |
| Default: | DBMS |
| Data source: | Amazon Redshift, Aster, DB2 under UNIX and PC Hosts, DB2 under z/OS, Google BigQuery, Greenplum, Hadoop, HAWQ, Impala, Informix, JDBC, Microsoft SQL Server, MySQL, Netezza, ODBC, OLE DB, Oracle, PostgreSQL, SAP HANA, SAP ASE, SAP IQ, Snowflake, Teradata, Vertica, Yellowbrick |
| Note: | Support for Yellowbrick was added in SAS 9.4M7. |
| See: | DBGEN_NAME= data set option, VALIDVARNAME= system option |
Table of Contents
specifies that SAS renames DBMS columns to valid SAS variable names. SAS converts to underscores any characters that it does not allow. If it converts a column to a name that already exists, it appends a sequence number at the end of the new name.
specifies that SAS converts DBMS columns that contain characters that SAS does not allow into valid SAS variable names. SAS uses the format _COLn, where n is the column number, starting with 0. If SAS converts a name to a name that already exists, it appends a sequence number at the end of the new name.
SAS retains column names
when it reads data from DBMS tables 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 for the conversion of kanji to English characters. English characters that are converted from kanji are often those that SAS does not allow. Although this option works for the single-byte character set (SBCS) version of SAS, SAS ignores it in the double-byte character set (DBCS) version. So if you have the DBCS version, you must first specify VALIDVARNAME=ANY before using your language characters as column variables.
If you specify DBGEN_NAME=SAS,
SAS renames a DBMS column named Dept$Amt to _COLn.
If you specify DBGEN_NAME=DBMS, SAS renames the Dept$Amt column
to Dept_Amt.