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

Demonstrate capability to query data from multiple tables using SQL JOINS. Create and modify database table and index structures. Maintain table data integrity through constraints. Understand how to ...