184 DBPROMPT= Data Set Option Chapter 10
DBPROMPT= Data Set Option
Specifies whether SAS displays a window that prompts the user to enter DBMS connection
information
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
Oracle, SYBASE
Default value:
NO
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 Details: The interface to Oracle allows you to enter 30 characters each for the
USERNAME and PASSWORD and up to 70 characters for the PATH, depending on
your platform and terminal type.
Examples
In the following 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;
In the following example, the DBPROMPT window opens during connection to the
DBMS. Values that were previously specified during the creation of MYVIEW are pulled
