calcuate sensitivity specificity PPV etc in the data set by depatment name

[chuie]

Hi All,

I have a data set with the binary predicted value and actual value for each department. I would like to calculate sensitivity, specificity, PPV,NPV, Accuracy etc by department name.

I can calculate overall by creating confusion matrix ( 2* 2 table)  but how to calculate  each measures BY department? where do I place the BY statement in the following code or please suggest other way.

Thank you

my data:

ID          Department   predictive    actual

 1                     A                  0              1

  2                    A                  1               0

  3                    A                  1               1

  4                    B                   0               0

.

.

.

.

title 'Sensitivity';

proc freq data=Comp;

where Response=1;

weight Count;

tables Test / binomial(level="1");

exact binomial;

run;

[Reeza · Accepted solution]

where do I place the BY statement in the following code or please suggest other way.

Anywhere, but usually right after the PROC FREQ statement.

title 'Sensitivity';
proc freq data=Comp;
where Response=1;
BY department;
weight Count;
tables Test / binomial(level="1");
exact binomial;
run;

http://support.sas.com/kb/24/170.html