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

Get The Little SAS® Book for Enterprise Guide® 4.1 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.