SAS Certification Prep Guide, 4th Edition

Using the UNION Set Operator

Overview

The set operator UNION does both of the following:

• selects unique rows from both tables
• overlays columns.

The following example demonstrates how UNION works when used alone and with the keywords ALL and CORR.

Using the UNION Operator Alone

To display all rows from the tables One and Two that are unique in the combined set of rows from both tables, use a PROC SQL set operation that includes the UNION operator:

proc sql; select * from one union select * from two;

With the UNION operator, ...