https://communities.sas.com/t5/ODS-and-Base-Reporting/assigning-values-to-codes-for-sorting/m-p/1338#M616 Hi,<BR /> <BR /> How do we assign an order to set of values in FORMAT so I can use them for sorting?<BR /> <BR /> For example, let's say there are five values for "visit code" format - "Screening", "Day1", "Day5", "W6" and "EXIT". Can I assign a sorting order to these values so that they will always be sorted in this order when I apply PROC SORT to a dataset?<BR /> <BR /> Thank you.<BR /> <BR /> James Tue, 29 Aug 2006 15:24:13 GMT deleted_user 2006-08-29T15:24:13Z https://communities.sas.com/t5/ODS-and-Base-Reporting/assigning-values-to-codes-for-sorting/m-p/1338#M616 Hi,<BR /> <BR /> How do we assign an order to set of values in FORMAT so I can use them for sorting?<BR /> <BR /> For example, let's say there are five values for "visit code" format - "Screening", "Day1", "Day5", "W6" and "EXIT". Can I assign a sorting order to these values so that they will always be sorted in this order when I apply PROC SORT to a dataset?<BR /> <BR /> Thank you.<BR /> <BR /> James Tue, 29 Aug 2006 15:24:13 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/assigning-values-to-codes-for-sorting/m-p/1338#M616 deleted_user 2006-08-29T15:24:13Z https://communities.sas.com/t5/ODS-and-Base-Reporting/assigning-values-to-codes-for-sorting/m-p/1339#M617 This question is perhaps best answered by Technical Support. <BR /> You can submit it online at <A href="http://support.sas.com/ctx/supportform/index.jsp" target="_blank">http://support.sas.com/ctx/supportform/index.jsp</A> .<BR /> <BR /> -- David Kelley, SAS Wed, 30 Aug 2006 14:48:40 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/assigning-values-to-codes-for-sorting/m-p/1339#M617 David_SAS 2006-08-30T14:48:40Z