Because you cannot depend on your data to be sorted 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 ...