https://communities.sas.com/t5/SAS-Programming/how-to-reorder-proc-freq-2x2-tables/m-p/816372#M322216 <P>By default, PROC FREQ uses alphabetical order for character variables and numerical order for numeric variables.</P> <P>&nbsp;</P> <P>If you want some other order, sort the data first using DESCENDING so now POSITIVE appears in the data set before NEGATIVE. Then use</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">proc freq data=have order=data;</CODE></PRE> Fri, 03 Jun 2022 17:43:29 GMT PaigeMiller 2022-06-03T17:43:29Z https://communities.sas.com/t5/SAS-Programming/how-to-reorder-proc-freq-2x2-tables/m-p/816371#M322215 <P>Hello,</P><P>&nbsp;</P><P>Is it possible to reorder the proc freq output? Basically I want "Negative" to be located where "Positive" is and vice-versa (see screenshot) .&nbsp; Thank you</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HitmonTran_0-1654277889142.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/71985iAE3ACED2284F949E/image-size/medium?v=v2&amp;px=400" role="button" title="HitmonTran_0-1654277889142.png" alt="HitmonTran_0-1654277889142.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Fri, 03 Jun 2022 17:45:11 GMT https://communities.sas.com/t5/SAS-Programming/how-to-reorder-proc-freq-2x2-tables/m-p/816371#M322215 HitmonTran 2022-06-03T17:45:11Z https://communities.sas.com/t5/SAS-Programming/how-to-reorder-proc-freq-2x2-tables/m-p/816372#M322216 <P>By default, PROC FREQ uses alphabetical order for character variables and numerical order for numeric variables.</P> <P>&nbsp;</P> <P>If you want some other order, sort the data first using DESCENDING so now POSITIVE appears in the data set before NEGATIVE. Then use</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">proc freq data=have order=data;</CODE></PRE> Fri, 03 Jun 2022 17:43:29 GMT https://communities.sas.com/t5/SAS-Programming/how-to-reorder-proc-freq-2x2-tables/m-p/816372#M322216 PaigeMiller 2022-06-03T17:43:29Z