PROC SQL allows a subquery (contained in parentheses) at any point in an expression where a simple column value or constant can be used. In this case, a subquery must return a single value, that is, ...

PROC SQL provides traditional set operators from relational algebra: OUTER UNION concatenates the query results. UNION produces all unique rows from both queries. ... has no name in the first ...