It is more efficient to omit the ORDER BY clause when you are creating the view and specify it as needed when you reference the view in queries. Note: If you specify the NUMBER option in the PROC SQL ...

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