Rows and columns in the table for Sensitivity calculation are in reversed order

Barkat — Tue, 13 Sep 2022 00:32:26 GMT

In my dataset I have two variables, Test and Standard. Both have two options, Pos and Neg. When I run the following SAS code then the output table shows Pos and Neg in reverse order, so results are reversed. How can I fix it.

Proc freq data=have;

tables Test*Standard/senspec;

run;

I get the following table as output

	Neg	Pos
Neg
Pos

I want the following table as output

	Pos	Neg
Pos
Neg

Re: Rows and columns in the table for Sensitivity calculation are in reversed order

ballardw — Tue, 13 Sep 2022 16:24:54 GMT

N comes before P alphabetically. So that is the default order you will get from the output of Proc Freq.

If the order is that important try:

Proc sort data=have;
   by descending test descending standard;
run;

Proc freq data=have order=data;
   tables test*standard;
run;

The sort places Pos before Neg and the Proc Freq option order=data tells SAS to display data in the order encountered in the data set instead of the default internal order.

Another approach is to create numeric variables with the value 1= first to display, 2= second to display and so on. Then create a custom format to display the desired text. Use that format in Proc Freq. By default the order would be the internal 1, 2, 3 (etc) but the formatted value will appear.

topic Rows and columns in the table for Sensitivity calculation are in reversed order in New SAS User

Rows and columns in the table for Sensitivity calculation are in reversed order

Re: Rows and columns in the table for Sensitivity calculation are in reversed order