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

chuie — Thu, 08 Mar 2018 22:18:19 GMT

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;

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

Reeza — Thu, 08 Mar 2018 22:26:05 GMT

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

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

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

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