This example accesses ORACLE data. First, you specify a PROC SQL CONNECT statement to connect to a particular ORACLE database that resides on a remote server. You refer to the database with the alias ...

from connection to sybase (select SALARY from EMPLOYEES where DEPT like &dept)); %put &sqlxmsg; disconnect from sybase; quit; When a PROC SQL query contains subqueries or inline views, the innermost ...