If you're working with relational databases, there's a good chance you've already written complex SQL queries with multiple joins, filters, aggregations, and nested subqueries. But have you ever ...
PROC SQL allows you to specify the ORDER BY clause in the CREATE VIEW statement. Every time a view is accessed, its data are sorted and displayed as specified by the ORDER BY clause. This sorting on ...