Adding a Join

Drag and Drop Join Lines
Use the Joins Tab

Drag and Drop 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.

Use the Joins Tab

To add a join manually:
  1. Click the Joins tab.
  2. Click the Add a join button.
  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 the Add a join condition button 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 the Save button to save the join condition with the data query.
Copyright © SAS Institute Inc. All rights reserved.