Preserves spaces, special characters, reserved words, and case sensitivity in DBMS table names.
Valid in: | LIBNAME statement |
Default: | NO |
Supports: | All |
specifies that when you create tables or refer to an existing table, the table names are derived from SAS member names by using SAS member name normalization. However, most databases apply DBMS-specific normalization rules to the SAS member names. Therefore, the table names are created or referenced in the database following the DBMS-specific normalization rules.
Due
to the PRESERVE_TAB_NAMES=NO LIBNAME option setting, 12 table(s) have
not been displayed.
specifies that table names are read from and passed to the data source with any special characters, reserved words, and the exact, case-sensitive spelling of the name preserved. For Teradata, YES is the only supported value for this option. For SAS data sets, you need this option only if you are using an SQL reserved word as a table name. In all other cases, a valid SAS name must be used.
libname mydblib fedsvr server="d1234.us.company.com" port=2171 user=user1 pwd=pass1 dsn=oradsn; proc sql dquote=ansi; select * from mydblib."my table";
libname mydblib fedsvr server="d1234.us.company.com" port=2171 user=user1 pwd=pass1 dsn=oradsn preserve_tab_names=yes; proc print data=mydblib.'my table'n; run;