In a correlated subquery, the WHERE expression in a subquery refers to values in a table in the outer query. The correlated subquery is evaluated for each row in the outer query. With correlated ...

If the query-expression involves more than two table-expressions ... CORR causes PROC SQL to match the columns in table-expressions by name and not by ordinal position. Columns that do not match by ...