Specifies whether SAS displays a window in SAS Display Manager that prompts you to enter DBMS connection information.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | LIBNAME option value [Amazon Redshift, Aster, DB2 under UNIX and PC Hosts, Greenplum, Impala, Microsoft SQL Server, MySQL, Netezza, ODBC, PostgreSQL, SAP HANA, SAP IQ, Snowflake, Yellowbrick] |
| NO [SAP ASE, Vertica] | |
| Restriction: | This option is not applicable to SAS Viya. |
| Data source: | Amazon Redshift, Aster, DB2 under UNIX and PC Hosts, Greenplum, HAWQ, Impala, Microsoft SQL Server, MySQL, Netezza, ODBC, PostgreSQL, SAP ASE, SAP HANA, SAP IQ, Snowflake, Vertica, Yellowbrick |
| Note: | Support for Yellowbrick was added in SAS 9.4M7. |
| See: | DBPROMPT= LIBNAME option |
Table of Contents
displays the prompting window.
does not display the prompting window.
This data set option is supported only for view descriptors.
Oracle: You can enter 30 characters in the Oracle interface each for the user name and password and up to 70 characters for the path, depending on your platform and terminal type.
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=myusr1;
password=mypwd1;
table=dept;
create vlib.myview.view;
select all;
run;
proc print data=vlib.myview;
run;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;