The default value of
NO is overridden if DBPROMPT=YES.
The DEFER= option is
ignored when CONNECTION=UNIQUE because a connection is performed
every time a table is opened.
HP
Neoview, Microsoft SQL Server, Netezza, ODBC: When
you set DEFER=YES, you must also set the PRESERVE_TAB_NAMES= and PRESERVE_COL_NAMES=
options to the values that you want. Normally, SAS queries the data
source to determine the correct defaults for these options during
LIBNAME assignment, but setting DEFER=YES postpones the connection.
Because these values must be set at the time of LIBNAME assignment,
you must assign them explicitly when you set DEFER=YES.