SAS Certification Prep Guide, 4th Edition

Using the EXCEPT Set Operator

Overview

The set operator EXCEPT does both of the following:

• selects unique rows from the first table (the table specified in the first query) that are not found in the second table (the table specified in the second query)
• overlays columns.

Consider how EXCEPT works when used alone and with the keywords ALL and CORR.

Using the EXCEPT Operator Alone

Suppose you want to display the unique rows in table One that are not found in table Two. The PROC SQL set operation that includes the EXCEPT operator, the tables One and Two, and the output of the set operation are shown below:

proc sql; select ...