https://communities.sas.com/t5/SAS-Programming/Proc-freq/m-p/76215#M16455 Did you consider the ORDER=FREQ parameter on the PROC FREQ statement?<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Wed, 04 Mar 2009 18:39:00 GMT sbb 2009-03-04T18:39:00Z https://communities.sas.com/t5/SAS-Programming/Proc-freq/m-p/76214#M16454 proc freq by default displays crosstab in ascending order as shown below. Is it possible to have the crosstab display in descending order? I need to have the tabs display 5 to 1 . Thanks!<BR /> <BR /> proc freq data=star ;<BR /> tables A1_1*A1_2 / nopercent nocol norow;<BR /> run;.<BR /> <BR /> <BR /> The FREQ Procedure<BR /> <BR /> Table of A1_1 by A1_2<BR /> <BR /> A1_1(A1_1) A1_2(A1_2)<BR /> <BR /> Frequency 2 3 4 5 Total<BR /> ______________________________________________________<BR /> 2 13 17 0 0 30<BR /> ______________________________________________________<BR /> 3 21 190 13 0 224<BR /> _____________________________________________________<BR /> 4 6 80 54 11 151<BR /> ______________________________________________________<BR /> 5 0 52 54 122 228<BR /> ______________________________________________________<BR /> Total 40 339 121 133 633<BR /> <BR /> Frequency Missing = 5 Wed, 04 Mar 2009 15:11:43 GMT https://communities.sas.com/t5/SAS-Programming/Proc-freq/m-p/76214#M16454 SASPhile 2009-03-04T15:11:43Z https://communities.sas.com/t5/SAS-Programming/Proc-freq/m-p/76215#M16455 Did you consider the ORDER=FREQ parameter on the PROC FREQ statement?<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Wed, 04 Mar 2009 18:39:00 GMT https://communities.sas.com/t5/SAS-Programming/Proc-freq/m-p/76215#M16455 sbb 2009-03-04T18:39:00Z