PROC SQL allows you to specify the ORDER BY clause in the CREATE VIEW statement. Every time a view is accessed ... especially if the view's underlying tables are large. It is more efficient to omit ...

It is also useful if you are running SQL statements from an SQL application in another ... create a view from the query expression instead of a table. See CREATE VIEW Statement.