SAS Certification Prep Guide, 4th Edition

Using the OUTER UNION Set Operator

Overview

The set operator OUTER UNION concatenates the results of the queries by the following:

• selecting all rows (both unique and nonunique) from both tables
• not overlaying columns.

We can demonstrate how OUTER UNION works when used alone and with the keyword CORR. The ALL keyword is not used with OUTER UNION because this operator's default action is to include all rows in output.

Using the OUTER UNION Operator Alone

Suppose you want to display all rows from both of the tables One and Two, without overlaying columns. The PROC SQL set operation that includes the OUTER UNION operator, the ...