The PRESERVE_COL_NAMES=
and PRESERVE_TAB_NAMES= LIBNAME options determine how
SAS/ACCESS Interface
to Microsoft SQL Server handles case sensitivity, spaces, and special
characters. (For information about these options, see
Overview: LIBNAME Statement for Relational Databases .) The default value for both of these options is YES for
Microsoft Access, Microsoft Excel, and Microsoft SQL Server; NO for
all others. For additional information about these options, see
Overview: LIBNAME Statement for Relational Databases .
Microsoft SQL Server
supports table names and column names that contain up to 32 characters.
If DBMS column names are longer than 32 characters, SAS truncates
them to 32 characters. If truncating a column name would result in
identical names, SAS generates a unique name by replacing the last
character with a number. DBMS table names must be 32 characters or
less because SAS does
not truncate
a longer name. If you already have a table name that is greater than
32 characters, it is recommended that you create a table view.