Selecting which rows to keep

Suppose the Fire and Ice Tours company wants to expand the number of tours that it offers in Europe. The company 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 change the type of join.

To reopen the query, right-click the Query Builder icon in the Project Tree or Process Flow and select Modify Query Builder or simply click Modify Task on the workspace toolbar for the query result.