For example ... in the DBMS, you must sort the data at the time of query, by using an ORDER BY clause in PROC SQL, a BY statement in the DATA step, the SAS/ACCESS data set option DBCONDITION= ...