O'Reilly logo

The Little SAS® Book for Enterprise Guide® 4.1 by Lora D. Delwiche, Susan J. Slaughter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required