The previous examples showed how to read DBMS data and perform operations on the data in SAS. You can also perform operations on data directly in your DBMS by using the SQL procedure. The following ...

In this example, two large DBMS tables, TABLE1 and TABLE2, have a column named DEPTNO. An inner join of these tables is performed where the DEPTNO value in TABLE1 is equal to the DEPTNO value in ...