Adding a Join

Dragging and Dropping Join Lines
Using the Joins Tab

Dragging and Dropping Join Lines

To add a join by selecting a column name and dragging your pointer to another column:
  1. Place your pointer on one of the columns in a table to use, and then click and drag your pointer to a column in the other table to use in the join.
  2. If you want a join type other than an inner join, select the join, right-click, and then select the join type.
Tip
The first table that is added to the workspace is always set as the left table. You can switch the right table and left table by using the Joins tab.

Using the Joins Tab

To add a join condition by specifying the join properties:
  1. Click the Joins tab.
  2. Click Add a join.
  3. Use the menus to replace Not Selected with the table names to use in the join. Click Save.
  4. The default join type is an inner join. Use the menu in the Join Type column to select a different join type.
  5. Click Add a join condition in the Join conditions area.
  6. Use the menus to replace Not Selected with the column names to use in the join condition. Click Save.
  7. Click Save to save the join condition with the query.
Copyright © SAS Institute Inc. All rights reserved.