For this example you create a view descriptor, VLIB.ALLEMP, based on SYBASE data. The outer PROC SQL query retrieves data from the view descriptor; the subquery uses a Pass-Through query to retrieve ...

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