topic Re: SORTING in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/SORTING/m-p/178386#M45566 <HTML><HEAD></HEAD><BODY><P>I was trying to acheive this in PROC REPORT...</P><P>Thanks</P></BODY></HTML> Thu, 19 Dec 2013 21:01:52 GMT robertrao 2013-12-19T21:01:52Z SORTING https://communities.sas.com/t5/SAS-Procedures/SORTING/m-p/178383#M45563 <HTML><HEAD></HEAD><BODY><P>when we have a charecter variable which has values like shown below:</P><P>0,1,2,3,4, MISSING(word)</P><P>HOW DOES IT SORT??????</P><P>i am getting the followwing order:</P><P>0</P><P>1</P><P>2</P><P>3</P><P>4</P><P>MISSING</P><P></P><P>Is there any way we can do :</P><P>MISSING</P><P>0</P><P>1</P><P>2</P><P>3</P><P>4</P><P></P><P></P><P>Thanks</P></BODY></HTML> Thu, 19 Dec 2013 19:05:47 GMT https://communities.sas.com/t5/SAS-Procedures/SORTING/m-p/178383#M45563 robertrao 2013-12-19T19:05:47Z Re: SORTING https://communities.sas.com/t5/SAS-Procedures/SORTING/m-p/178384#M45564 <HTML><HEAD></HEAD><BODY><P>What technique are you using to perform the sort? PROC SORT? PROC SQL? Something else? What platform are you running SAS on?</P></BODY></HTML> Thu, 19 Dec 2013 20:41:48 GMT https://communities.sas.com/t5/SAS-Procedures/SORTING/m-p/178384#M45564 Fugue 2013-12-19T20:41:48Z Re: SORTING https://communities.sas.com/t5/SAS-Procedures/SORTING/m-p/178385#M45565 <HTML><HEAD></HEAD><BODY><P>You can specify a COLLATING SEQUENCE in proc sort that would do that. But you will have to make it.</P><P>Or a translation table Proc Trantab gets you started.</P><P></P><P>Personally, I wouldn't have made them character if I wan'ted them to sort that way as Missing, as a numeric, comes first, especially if all the values concerned except MISSING are number values. Then us a FORMAT to display the text if that's important.</P><P><BR /> </P></BODY></HTML> Thu, 19 Dec 2013 20:50:11 GMT https://communities.sas.com/t5/SAS-Procedures/SORTING/m-p/178385#M45565 ballardw 2013-12-19T20:50:11Z Re: SORTING https://communities.sas.com/t5/SAS-Procedures/SORTING/m-p/178386#M45566 <HTML><HEAD></HEAD><BODY><P>I was trying to acheive this in PROC REPORT...</P><P>Thanks</P></BODY></HTML> Thu, 19 Dec 2013 21:01:52 GMT https://communities.sas.com/t5/SAS-Procedures/SORTING/m-p/178386#M45566 robertrao 2013-12-19T21:01:52Z Re: SORTING https://communities.sas.com/t5/SAS-Procedures/SORTING/m-p/178387#M45567 <HTML><HEAD></HEAD><BODY><P>The quickest way would be to recode the variable to numeric.</P></BODY></HTML> Thu, 19 Dec 2013 23:47:28 GMT https://communities.sas.com/t5/SAS-Procedures/SORTING/m-p/178387#M45567 Fugue 2013-12-19T23:47:28Z