To change how SAS handles case-sensitive or nonstandard DBMS table and column names, specify one or more of these options.
This option applies only to creating DBMS tables. When set to YES, it preserves spaces, special characters, and mixed case in DBMS column names. For more information, see the PRESERVE_COL_NAMES= LIBNAME and data set options.
SAP HANA: When this option is set to YES, you are allowed to use SAP HANA reserved words as column names.
When set to YES, this option preserves blank spaces, special characters, and mixed case in DBMS table names. Specify the PRESERVE_NAMES=YES | NO alias if you plan to specify both the PRESERVE_COL_NAMES= and PRESERVE_TAB_NAMES= options in your LIBNAME statement. Using this alias saves you time when you are coding. For more information, see the PRESERVE_TAB_NAMES= LIBNAME option.
SAP HANA: When this option is set to YES, you are allowed to use SAP HANA reserved words as table names.
This PROC SQL option specifies whether PROC SQL treats values within double quotation marks as a character string, or as a column name or table name. When you specify DQUOTE=ANSI, your SAS code can refer to DBMS names that contain characters and spaces that SAS naming conventions do not allow. By specifying DQUOTE=ANSI, you can preserve special characters in table and column names in your SQL statements by enclosing the names in double quotation marks. To preserve table names, you must also specify PRESERVE_TAB_NAMES=YES. To preserve column names when you create a table, you must also specify PRESERVE_COL_NAMES=YES.
This global system option allows you to include national characters and some special characters in a data set name. For more information, see VALIDMEMNAME= System Option in SAS System Options: Reference.
This global system option can override SAS naming conventions. For more information, see the VALIDVARNAME= system option.
Examples that use these options are available. The availability of these options and their default values are DBMS-specific, so see the SAS/ACCESS documentation for your DBMS to learn how the SAS/ACCESS engine for your DBMS processes names.
For general information about naming, see Rules for Most SAS Names in SAS Programmer’s Guide: Essentials.