turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- Analytics
- /
- Stat Procs
- /
- calcuate sensitivity specificity PPV etc in the da...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

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

Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

2 weeks ago

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

Solution

2 weeks ago

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to chuie

2 weeks ago

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

Solution

2 weeks ago

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to chuie

2 weeks ago

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