topic Re: Creating a 2x2 table in Proc Report in SAS Programming

Creating a 2x2 table in Proc Report

daszlosek — Mon, 26 Jun 2017 16:40:30 GMT

Hello,

I would like to report the following count data:

TP	FN	FP	TN
12	110	14	99

in a proc report as the following:

		Gold Standard
		+	-
Result	+	12	14
Result	-	110	99

I am having some difficulty as to how I can manipulate the cells/ add rows. I would think this was a common problem, but I am having difficulty googling it. Below is the SAS code for the dataset:

data ex1;
input TP    FN    FP     TN;
cards;
12 110 14 99
;
run;

Any suggestions or links to the right direction would be much appreciated,

Re: Creating a 2x2 table in Proc Report

PaigeMiller — Mon, 26 Jun 2017 16:51:45 GMT

If you read in your data differently so that each row has only one data point, and a + or - value for Gold Standard, and another + or - value for Result, then you're all set. See http://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=proc&docsetTarget=n1pl56sdqo09cyn1fifuhcz8dl2f.htm&locale=en

data have;
    input gold_standard $ result $ value;
+ + 12
+ - 110
- + 14
- - 99
;
run;

Re: Creating a 2x2 table in Proc Report

daszlosek — Mon, 26 Jun 2017 17:02:06 GMT

I can see that I could just transpose the data to get it into that format, but I am not seeing how, in proc report, I could get the 12 adjacent to the 14. In the past using proc report I have just added columns, not rows.

Re: Creating a 2x2 table in Proc Report

PaigeMiller — Mon, 26 Jun 2017 17:08:23 GMT

I gave the link to an example that does this.

Re: Creating a 2x2 table in Proc Report

daszlosek — Mon, 26 Jun 2017 20:17:34 GMT

Yes, my apologies didn't see the link. With a little tweaking I was able to format the data the way I wanted.