Most ad hoc report writers know the default sort order (low to high) of the sort function can be changed by using the command HIGHEST. But did you know you can also specify a rank? You can even restrict the sort field values by specifying a number.
The syntax is: RANKED BY HIGHEST # fieldname
For example, the report request below will identify the top 3 employees with the highest paid positions.
To learn more about sorting data, refer to your FOCUS documentation/user manual.
Report Request:
EX AC
TABLE FILE AC
PRINT AC:LASTNAME
RANKED BY HIGHEST 3 AC:BASEPAY
END
Report Generated:
RANK AC:BASEPAY LASTNAME
---- ---------- ---------
1 $16,667.00 GIRAFFE
2 $13,166.00 SNAKE
3 $11,900.00 BEAR
Last Updated: February 27, 2024