As a result, you can now create a PROC SQL view, DATA step view, or SAS/ACCESS view with DBMS data. For this example you create a view descriptor, VLIB.ALLEMP, based on SYBASE data. The outer PROC SQL ...

[!INCLUDESQL Server] You can use the results of one query as the input for another. You can use the results of a subquery as a statement that uses the IN( ) function, the EXISTS operator, or the FROM ...