Changing the Order of the Sorting

By default, sorting is from the lowest to the highest value. You can reverse this order by adding the keyword HIGHEST to the sort phrase.

Issue the following request:

TABLE FILE EMPLOYEE
SUM DED_AMT
BY HIGHEST DED_CODE
ACROSS DEPARTMENT
END

Run the request. The output is:

The DED_CODE field stores alphanumeric data which normally displays in a low-to-high order (alphabetically, A to Z is low to high). This makes the first record CITY and the last record STAT. By adding HIGHEST to the sort phrase, you reverse the order of sorting.