SAS/ACCESS Interface to SYSTEM 2000 Data Management Software: Reference, Version 7-1

SYSTEM 2000 Ordering-clause

Note: When you include a SYSTEM 2000 ordering-clause in a view descriptor, you can specify a terminator (either a colon or a semicolon). But if you specify both a where-clause and an ordering-clause, do not use a terminator between them. [cautend]

ORDERED BY sortkeys;

ORDERED BY: is the keyword designating an ordering-clause. You can also use ORDER BY, OB, and SORT.
sortkeys: is a component name, component number, or SAS variable name of a SYSTEM 2000 item included in the view descriptor. Use commas to separate sort keys. You can also specify either ascending or descending order for each sort key.
ASCENDING|ASCEND|ASC|LOW|LO: specifies that you want the data ordered by ascending values of the sortkey. Ascending is the default.
DESCENDING|DESCEND|DESC|HIGH|HI: specifies that you want the data ordered by descending values of the sortkey.

    order by department, desc salary