The DESCRIBE TABLE statement writes a CREATE TABLE statement to the SAS log for the table ... The DESCRIBE VIEW statement writes a view definition to the SAS log. If you use a PROC SQL view in the ...

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