The INTERSECT operator
compares and overlays columns in the same way as the EXCEPT operator,
by column position instead of column name. However, INTERSECT selects
rows differently and displays in output the unique rows that are common
to both tables.
The following PROC SQL
set operation uses the INTERSECT operator to combine the tables Col1
and Col2.