https://communities.sas.com/t5/SAS-Programming/Take-a-Row-having-value-quot-TOTAL-quot-to-the-extreme-End-of/m-p/494973#M130552 <P>For this particular set of data, you could use:</P> <P>&nbsp;</P> <P>proc sort data=have;</P> <P>by inp_status_ds;</P> <P>run;</P> Wed, 12 Sep 2018 18:47:35 GMT Astounding 2018-09-12T18:47:35Z https://communities.sas.com/t5/SAS-Programming/Take-a-Row-having-value-quot-TOTAL-quot-to-the-extreme-End-of/m-p/494749#M130445 <P>My Input table:</P><TABLE><TBODY><TR><TD><STRONG>inp_status_ds</STRONG></TD><TD><STRONG>Selected_082018</STRONG></TD><TD><STRONG>Selected_082218</STRONG></TD></TR><TR><TD>Bound</TD><TD>$134,104,152.35</TD><TD>$132,159,545.67</TD></TR><TR><TD>Declined</TD><TD>$1,277,887,802.55</TD><TD>$1,277,916,876.55</TD></TR><TR><TD>Deleted</TD><TD>$1,843,298.56</TD><TD>$1,843,298.56</TD></TR><TR><TD>In Progress</TD><TD>$890,400,353.32</TD><TD>$890,400,353.32</TD></TR><TR><TD>TOTAL</TD><TD>$2,954,563,587.84</TD><TD>$2,952,648,055.16</TD></TR><TR><TD>Lost</TD><TD>$624,359,889.70</TD><TD>$624,359,889.70</TD></TR><TR><TD>Quoted</TD><TD>$25,968,091.35</TD><TD>$25,968,091.35</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>I want my output table:</P><TABLE><TBODY><TR><TD><STRONG>inp_status_ds</STRONG></TD><TD><STRONG>Selected_082018</STRONG></TD><TD><STRONG>Selected_082218</STRONG></TD></TR><TR><TD>Bound</TD><TD>$134,104,152.35</TD><TD>$132,159,545.67</TD></TR><TR><TD>Declined</TD><TD>$1,277,887,802.55</TD><TD>$1,277,916,876.55</TD></TR><TR><TD>Deleted</TD><TD>$1,843,298.56</TD><TD>$1,843,298.56</TD></TR><TR><TD>In Progress</TD><TD>$890,400,353.32</TD><TD>$890,400,353.32</TD></TR><TR><TD>Lost</TD><TD>$624,359,889.70</TD><TD>$624,359,889.70</TD></TR><TR><TD>Quoted</TD><TD>$25,968,091.35</TD><TD>$25,968,091.35</TD></TR><TR><TD>TOTAL</TD><TD>$2,954,563,587.84</TD><TD>$2,952,648,055.16</TD></TR></TBODY></TABLE> Wed, 12 Sep 2018 09:34:02 GMT https://communities.sas.com/t5/SAS-Programming/Take-a-Row-having-value-quot-TOTAL-quot-to-the-extreme-End-of/m-p/494749#M130445 subrat1 2018-09-12T09:34:02Z https://communities.sas.com/t5/SAS-Programming/Take-a-Row-having-value-quot-TOTAL-quot-to-the-extreme-End-of/m-p/494754#M130446 <P>Post test data in the form of a datastep, as such this is untested:</P> <PRE>data want; set have (where=(inp_status_ds ne "TOTAL")) have (where=(inp_status_ds="TOTAL")); run;</PRE> Wed, 12 Sep 2018 09:45:29 GMT https://communities.sas.com/t5/SAS-Programming/Take-a-Row-having-value-quot-TOTAL-quot-to-the-extreme-End-of/m-p/494754#M130446 RW9 2018-09-12T09:45:29Z https://communities.sas.com/t5/SAS-Programming/Take-a-Row-having-value-quot-TOTAL-quot-to-the-extreme-End-of/m-p/494973#M130552 <P>For this particular set of data, you could use:</P> <P>&nbsp;</P> <P>proc sort data=have;</P> <P>by inp_status_ds;</P> <P>run;</P> Wed, 12 Sep 2018 18:47:35 GMT https://communities.sas.com/t5/SAS-Programming/Take-a-Row-having-value-quot-TOTAL-quot-to-the-extreme-End-of/m-p/494973#M130552 Astounding 2018-09-12T18:47:35Z