Solved
Contributor
Posts: 32

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

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;

Accepted Solutions
Highlighted
Solution
‎03-10-2018 10:38 AM
Super User
Posts: 23,700

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

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

All Replies
Highlighted
Solution
‎03-10-2018 10:38 AM
Super User
Posts: 23,700

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

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

☑ This topic is solved.