SAS 9.4 SQL Procedure User's Guide, Second Edition, 2nd Edition

Notice that OUTER UNION does not overlay columns from the two tables. To overlay

columns in the same position, use the CORRESPONDING keyword.

proc sql;

title 'A OUTER UNION CORR B';

select * from sql.a

outer union corr

select * from sql.b;

Output 3.39 Concatenating the Query Results (OUTER UNION CORR)

Producing Rows from the First Query or the Second Query

There is no keyword in PROC SQL that returns unique rows from the first and second

table, but not rows that occur in both. Here is one way that you can simulate this

operation:

(query1 except query2)

union

(query2 except query1)

This example shows how to use this operation.

proc sql;

title 'A EXCLUSIVE ...