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 |
- | 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,
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=n1pl56sdqo09...
data have;
input gold_standard $ result $ value;
+ + 12
+ - 110
- + 14
- - 99
;
run;
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=n1pl56sdqo09...
data have;
input gold_standard $ result $ value;
+ + 12
+ - 110
- + 14
- - 99
;
run;
I gave the link to an example that does this.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.