The SORT Procedure

Example 2: Reversing the Order of the Sorted Values

Procedure features:

BY statement option:

DESCENDING

Other features

PROC PRINT

Data set:

ACCOUNT

options nodate pageno=1 linesize=80 pagesize=60;

proc sort data=account out=sorted;

   by town descending debt accountnumber;
run;

proc print data=sorted;

   var company town debt accountnumber;
   title  'Customers with Past-Due Accounts';
   title2 'Listed by Town, Amount, Account Number';
run;

Output

Note that sorting last by AccountNumber puts the businesses in Apex with a debt of $37.95 in order of account number.

Note that sorting last by AccountNumber puts the businesses in Apex with a debt of $37.95 in order of account number.