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, ...

Each table-expression is evaluated to produce an (internal) intermediate result table. Each intermediate result table then becomes an operand linked with a set operator to form an expression, for ...