DBPROMPT= Data Set Option

Specifies whether SAS displays a window that prompts you to enter DBMS connection information.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: NO
Data source: Aster nCluster, Greenplum, HP Neoview, MySQL, Netezza, Oracle, Sybase, Sybase IQ
See: DBPROMPT= LIBNAME option

Syntax

DBPROMPT=YES | NO

Syntax Description

YES
displays the prompting window.
NO
does not display the prompting window.

Details

This data set option is supported only for view descriptors.
Oracle:
In the Oracle interface, you can enter 30 characters each for USERNAME and PASSWORD and up to 70 characters for PATH, depending on your platform and terminal type.

Examples

Example 1: Use the Default Value (No Prompt)

In this example, connection information is specified in the ACCESS procedure. The DBPROMPT= data set option defaults to NO during the PRINT procedure because it is not specified.
proc access dbms=oracle;
   create alib.mydesc.access;
   user=testuser;
   password=testpass;
   table=dept;
   create vlib.myview.view;
   select all;
run;
proc print data=vlib.myview;
run;

Example 2: Prompt for Connection Information

In the next example, the DBPROMPT window appears during connection to the DBMS. Values that were previously specified during the creation of MYVIEW are pulled into the DBPROMPT window fields. You must edit or accept the connection information in the DBPROMPT window to proceed. The password value appears as a series of asterisks; you can edit it.
proc print data=vlib.myview(dbprompt=yes);
run;