Take a Row having value "TOTAL" to the extreme End of the tabe

[subrat1]

My Input table:

inp_status_ds	Selected_082018	Selected_082218
Bound	$134,104,152.35	$132,159,545.67
Declined	$1,277,887,802.55	$1,277,916,876.55
Deleted	$1,843,298.56	$1,843,298.56
In Progress	$890,400,353.32	$890,400,353.32
TOTAL	$2,954,563,587.84	$2,952,648,055.16
Lost	$624,359,889.70	$624,359,889.70
Quoted	$25,968,091.35	$25,968,091.35

I want my output table:

inp_status_ds	Selected_082018	Selected_082218
Bound	$134,104,152.35	$132,159,545.67
Declined	$1,277,887,802.55	$1,277,916,876.55
Deleted	$1,843,298.56	$1,843,298.56
In Progress	$890,400,353.32	$890,400,353.32
Lost	$624,359,889.70	$624,359,889.70
Quoted	$25,968,091.35	$25,968,091.35
TOTAL	$2,954,563,587.84	$2,952,648,055.16

[RW9]

Post test data in the form of a datastep, as such this is untested:

data want;
  set have (where=(inp_status_ds ne "TOTAL"))
      have (where=(inp_status_ds="TOTAL"));
run;

[Astounding]

For this particular set of data, you could use:

proc sort data=have;

by inp_status_ds;

run;