The Little SAS® Book for Enterprise Guide® 4.1

5.3. Modifying a Join

By default, when you join tables, SAS Enterprise Guide keeps only rows for which a match is found. Sometimes that may be just what you want, but at other times, you may want to keep all the rows regardless of whether they match, or all the rows from one table, but not the other. To do this, use a modified join.

Reopening the Query window

To change a query that you have already run, right-click the query icon in the Project Explorer or Project Designer and select Open from the pop-up menu. The Query Builder window will open. Click the Join button to open the Tables and Joins window.

To modify a join, right-click the join ...