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

A clause is a statement that modifies results. Clauses are not required statements, but refine what and how data is displayed. The WHERE clause in a query is one example.

proc-sql-view specifies a PROC SQL view. ... described in ALTER TABLE Statement. In the SET clause, a column reference on the left side of the equal sign can also appear as part of the expression on ...