Any difference between union all corresponding and outer union corresponding?
sas, sql
Solution
It turns out there is, actually, a difference: how columns which only exist in one dataset are handled. `Outer Union Corresponding` will display columns that appear only in one dataset, not overlaid by position. `Union All Corresponding` will not display any columns that appear in only one dataset.
Problem
Could someone verify my understanding of proc sql union operations? My interpretation of the differences between outer union and union is the following: Union deletes duplicate rows, while outer union does not Union will overlay columns, while outer union, by default, will not. So, would there be any difference between union all corresponding and outer union corresponding? It seems like "ALL" would remove the first difference, and "CORRESPONDING" would remove the second difference, but I'm concerned there could be an additional difference between the two I'm not seeing.