PowerExchange for SAS User Guide for PowerCenter

Back Next

Joining tables in SAS

You can join tables in SAS by connecting the tables to one source qualifier. The SAS System performs the join.

The following attributes relate to the table join accessed through the

Join

tab in the source qualifier properties dialog box:

Join Type: The join type are the inner join, the full outer join, the left outer join, and the right outer join. In an inner join, more than two tables joins.
Join Condition: You can define the condition that defines the join to be executed by using the join condition. You must enter the join condition using the join condition builder dialog box that you can access by clicking the button next to the join condition field.
If you do not specify a join condition, a join condition generates based on the existing primary key-foreign key relations between the sources as defined in the source analyzer.
Left table: The selection of Left Outer Join or Right Outer Join as join type allows you to define which of the two participating tables is the Left table.