Suppose you want to
display the unique rows in table Col1 that are not found in table
Col2. The PROC SQL set operation that includes the EXCEPT operator,
the tables Col1 and Col2, and the output of the set operation are
shown below.
proc sql;
select *
from certadv.col1 except select * from certadv.col2; ...