| Current DBMS Table Name | Desired SAS Data Set Name | Required LIBNAME Option |
| default DBMS table name, such as STAFF | default SAS data set name (uppercase), such as STAFF |
preserve_tab_names=no |
| case-sensitive DBMS table name, such as Staff | case-sensitive SAS data set name, such as Staff |
preserve_tab_names=yes |
| DBMS table name with characters invalid for SAS names, such as All$Staff | nonstandard, case-sensitive SAS data set name , such as All$Staff |
proc sql dquote=ansi
and preserve_tab_names=yes or,
in a DATA or PROC step, use a SAS name literal such as 'All$Staff'n
and preserve_tab_names=yes |
Copyright © 2002 SAS Institute Inc.,
Cary, NC, USA. All rights reserved.