PROC SQL matches the columns by ordinal position. The set operators automatically eliminate duplicate rows from their output tables. The optional ALL keyword preserves the duplicate rows, reduces the ...