https://communities.sas.com/t5/SAS-Procedures/Sort/m-p/20661#M4297 Remove the "descending" in the by statement. Wed, 02 Mar 2011 19:49:29 GMT RickM 2011-03-02T19:49:29Z https://communities.sas.com/t5/SAS-Procedures/Sort/m-p/20660#M4296 Hi all,<BR /> <BR /> I submitted the below code:<BR /> <BR /> data QTR1_REVENUE ;<BR /> input destination $ revenue;<BR /> cards;<BR /> FRA 62129<BR /> FRA 75962<BR /> ;<BR /> run;<BR /> <BR /> proc sort data = qtr1_revenue;<BR /> by destination descending revenue;<BR /> run;<BR /> <BR /> In outuput data set I was expecting to see the following:<BR /> FRA 62129<BR /> FRA 75962<BR /> <BR /> but to my surprise,the output is :<BR /> FRA 75962<BR /> FRA 62129<BR /> <BR /> Just wondering why this happened.Any thoughts?<BR /> <BR /> Thanks in advance Wed, 02 Mar 2011 19:43:34 GMT https://communities.sas.com/t5/SAS-Procedures/Sort/m-p/20660#M4296 ren2010 2011-03-02T19:43:34Z https://communities.sas.com/t5/SAS-Procedures/Sort/m-p/20661#M4297 Remove the "descending" in the by statement. Wed, 02 Mar 2011 19:49:29 GMT https://communities.sas.com/t5/SAS-Procedures/Sort/m-p/20661#M4297 RickM 2011-03-02T19:49:29Z