DICTIONARY is a reserved libref for use only in PROC SQL. Data from DICTIONARY tables are generated at run time. You can use a PROC SQL query to retrieve or subset data from a DICTIONARY table. You ...

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