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 over one of the columns to use, and then click and drag your pointer to the 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 select the join type from the menu.
Tip
The first table that is added to the workspace is always set as the left table. You can switch the right and left tables 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 field.
  6. Use the menus to replace Not Selected with the column names to use for the join condition. Click Save.
  7. Click Save to save the join condition with the query.
Copyright © SAS Institute Inc. All rights reserved.