how to reorder proc freq 2x2 tables

[HitmonTran]

Hello,

Is it possible to reorder the proc freq output? Basically I want "Negative" to be located where "Positive" is and vice-versa (see screenshot) .  Thank you

[PaigeMiller · Accepted solution]

By default, PROC FREQ uses alphabetical order for character variables and numerical order for numeric variables.

If you want some other order, sort the data first using DESCENDING so now POSITIVE appears in the data set before NEGATIVE. Then use

proc freq data=have order=data;