Join Type. Supported join types are the inner join, full outer join, left outer join, and right outer join. Note that only in the case of an inner join more than two tables can be joined.

Join Condition. You can define the condition that defines the join to be executed. The join condition is entered using the join condition builder dialog that you can access by clicking the button next to the join condition field. For a full description of valid join conditions in SAS, see the SAS documentation. If no join condition is specified, a join condition will be generated based on the existing primary key and foreign key relations between the sources as defined for the data objects.

Left table. When you select left outer join or right outer join as the join type, this option lets you define which of the two participating tables is to be considered as the left table.