When PROC SQL executes the view, the stored query assigns the libref and establishes the DBMS connection using the information in the LIBNAME statement. The scope of the libref is local to the view, ...

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