the query's DBMS connection information is stored with the view. Therefore, when you reference the PROC SQL view in a SAS program, you automatically connect to the correct database, and you retrieve ...

Analyze database contents using basic, intermediate and advanced SQL statement syntax and usage. Demonstrate capability to query data from multiple tables using SQL JOINS. Create and modify database ...

The outer PROC SQL query retrieves data from the view descriptor; the subquery uses a Pass-Through query to retrieve data ... are case sensitive. Database identification statements and column names ...