When a PROC SQL query contains subqueries or inline views, the innermost query is evaluated first. In this example, data is retrieved from the SYBASE EMPLOYEES table and returned to the subquery for ...

an IN subquery where the column in the inner subquery is indexed correlated ... SAS maintains indexes for all changes to the table, whether the changes originate from PROC SQL or from some other ...