Manage Joins in a Data Query
Once a join is added to a data query, you can change the join by selecting it in the workspace, right-clicking, and changing the join type or removing the join condition.
You can also change
a join by clicking the Joins tab, and then
selecting the row in the table. You can make the following changes:
-
add and remove tables from the join list
-
reorder the sequence of joins by moving them up or down
-
switch the left table and right table assignments for a join
-
add, remove, and change the columns that are used in the join condition
The Joins tab shows the join condition for the entire data query. Make sure that you select
a row in the upper table to set the columns in the Join
conditions area.
The workspace shows a link between the tables that are used in a join. If you specify
a left join
or right join, then the 
icon reflects which table provides the bulk of the
data. If you rearrange the tables in the workspace (switching the
left table and right table), then the icon continues to reflect which table provides the
bulk of the data. In order to change the data relationship, use either
of the following methods:
icon reflects which table provides the bulk of the
data. If you rearrange the tables in the workspace (switching the
left table and right table), then the icon continues to reflect which table provides the
bulk of the data. In order to change the data relationship, use either
of the following methods:
-
Switch the left table and right table by selecting a row from the table, and clicking
.
-
Change the join type from left to right or from right to left.
Copyright © SAS Institute Inc. All rights reserved.