Specifies whether a window prompts the user to enter connection information before connecting to the data source in interactive mode.
Valid in: | LIBNAME statement |
Default: | NO |
Supports: | All |
specifies that a window interactively prompts you for the data source connection options the first time the libref is used.
specifies that you are not prompted for the data source connection options. You must specify either a DSN definition or a fully specified connection string using CONNECT_STRING=. NO is the default.
user1
and basedsn
appear
in the DBPROMPT window and can be edited
and confirmed by the user. The password value appears in the DBPROMPT window
as a series of asterisks; it can also be edited by the user.
libname seclib fedsvr server="d1234.us.company.com" port=2171 user=user1 pwd=pass1 dsn=basedsn dbprompt=yes defer=no;
user1
and basedsn
appear
in the DBPROMPT window and can be edited
and confirmed by the user. The password value appears in the DBPROMPT window
as a series of asterisks; it can also be edited by the user. Upon
confirmation, the connection is made, and the table is opened.
libname seclib fedsvr server="d1234.us.company.com" port=2171 user=user1 pwd=pass1 dsn=basedsn dbprompt=yes defer=yes; proc print data=lib1.staff; run;