The tables in this
section illustrate how
SAS/ACCESS handles variable names when it creates
such DBMS objects as tables and views. This information applies generally
to all interfaces. However, in some cases you need not specify these
options because the option default values are DBMS-specific. For details,
see the documentation for your DBMS.
Examples are available that illustrate the different types of naming
actions and defaults.
SAS Variable Names to DBMS Column Names When Creating Tables
SAS Variable Name as
Input
|
|
|
Any SAS variable name,
such as Miles
|
Default DBMS column
name (normalized to follow the DBMS's naming conventions), such as
MILES
|
|
A case-sensitive SAS
variable name, such as Miles
|
Case-sensitive DBMS
column name, such as Miles
|
|
A SAS variable name
with characters that are not valid in a normalized SAS name, such
as Miles-to-Go
|
Case-sensitive DBMS
column name that matches the SAS name, such as Miles-to-Go
|
PROC SQL DQUOTE=ANSI
and PRESERVE_COL_NAMES=YES or, in a DATA or PROC step, use a SAS name
literal and PRESERVE_COL_NAMES=YES and VALIDVARNAME=ANY
|
SAS Data Set Names to DBMS Table Names
SAS Data Set Name as
Input
|
|
|
Any SAS data set name,
such as Payroll
|
Default DBMS table name
(normalized to follow the DBMS's naming conventions), such as PAYROLL
|
|
Case-sensitive SAS data
set name, such as Payroll
|
Case-sensitive DBMS
table name, such as Payroll
|
|
Case-sensitive SAS data
set name with characters that are not valid in a normalized SAS name,
such as Payroll-for-QC
|
Case-sensitive DBMS
table name that matches the SAS name, such as Payroll-for-QC
|
PROC SQL DQUOTE=ANSI
and PRESERVE_TAB_NAMES=YES or, in a DATA or PROC step, use a SAS name
literal and PRESERVE_TAB_NAMES=YES
|