SQL in SAS
STAT 342 – Fall 2020 Tutorial – 11
The Structure of a SQL Query
Concatenating Data:
Many to Many with Proc SQL
Combining Data with Set Operators
• Union
• Union all
• Except
• Exceptall
• Intercsect
• Outerunion
• Outerunioncorr