180 DBMASTER= Data Set Option Chapter 10
Example
In this example, SAS sends MYORADB.EMPLOYEES to Oracle as
EMPLOYEES@SALES.HQ.ACME.COM.
proc print data=myoradb.employees(dblink=
’sales.hq.acme.com’);
run;
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “DBLINK= LIBNAME Option” on page 91.
DBMASTER= Data Set Option
Used to designate which table is the larger table when you are processing a join that involves
tables from two different types of databases
Valid in:
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: DB2 OS/390, DB2 UNIX/PC, Informix, ODBC, OLE DB, Oracle, Microsoft
SQL Server, SYBASE, Teradata
Default value: none
Syntax
DBMASTER=YES
Syntax Description
YES
designates which of two tables references in a join operation is the larger table.
Example
In the following example, a table from an Oracle database and a table from a DB2
database are joined. DBMASTER is set to YES to indicate that the Oracle table is the
larger table. The DB2 table is the smaller table.
libname mydblib oracle user=testuser /*database 1 */
pw=testpass path=’myorapath’
libname mydblib2 db2 user=testuser /*database 2 */
pw=testpass path=’mydb2path’;
proc sql;
