Programming the statistical procedures from SAS

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

Accepted Solution Solved
Reply
Contributor
Posts: 32
Accepted Solution

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

 

View solution in original post


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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 119 views
  • 0 likes
  • 2 in conversation