Managing Joins in a Query :: SAS(R) Visual Analytics 6.1: User's Guide

Once a join is added to a query, you can change the join by selecting it on the workspace, right-clicking, and changing the join type or removing the join.

You can also change a join by selecting the Joins tab and then selecting the row in the table. You can change the following:

add and remove tables from the join list
reorder the sequence of joins by moving them up or down
swap the left and right table assignments for a join
add, remove, and change the columns that are used for the join condition

The Joins tab shows the join condition for the entire query. Make sure that you select a row in the upper table to set the columns in the Join condition.

The workspace shows a link between the tables that are used in a join. If you specify a left or right join, the Venn diagram icon reflects which table provides the bulk of the data. If you rearrange the table icons in the workspace (switching them from left to right), the Venn diagram icon continues to represent which table contributes the bulk of the data. In order to change the data relationship, use either of the following:

Swap the left and right tables by selecting the row from the table and clicking .
Change the join type from left to right, or from right to left.