| Current SAS Data Set Name | Desired DBMS Table Name | Required LIBNAME Option |
any SAS data set name, such as Payroll |
default DBMS table name (following DBMS naming conventions), such as PAYROLL | preserve_tab_names=no |
case-sensitive SAS data set name, such as Payroll |
case-sensitive DBMS table name, such as Payroll | preserve_tab_names=yes |
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 |
Copyright © 2002 SAS Institute Inc.,
Cary, NC, USA. All rights reserved.