The outer PROC SQL query retrieves data from the view descriptor ... and another set of parentheses enclose the entire subquery. When a comparison operator such as < or > is used in a WHERE clause, ...

The EXISTS condition is an operator whose right operand is a subquery. The result of an EXISTS condition ... Thus, the query returns all the employees from PROCLIB.PAYROLL who live in CT. proc sql; ...