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

Modifying the Type of Join

Suppose the Fire and Ice Tours company wants to expand the number of tours that it offers in Europe. It wants to include in the list all the volcanoes in Europe, not just volcanoes that currently have tours. In SAS Enterprise Guide the default action of a join is to include only the rows that appear in both tables. To change this default action, you need to modify the join.

Right-click the query icon in the Project Explorer or Project Designer and select Open to reopen the query.

Click Join to ...

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