turn on suggestions

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

Showing results for

- JMP User Community
- :
- Discussions
- :
- Counting rows

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 1, 2017 2:08 PM
(468 views)

I have a data set with multiple lines of data per individual. The lines of data are medical procedures and I want to get the average number of lines (or procedures) per individual. I'm not sure how to do that.

I was able to count the number of lines but I can't take the mean of that since everyone who has 5 lines also has 4 lines and 3 lines and so on. So basically what I think I need is for JMP to count the number of lines, but then only save the highest number. How can I do that?

The data structure is like this:

ID Count

001 1

001 2

001 3

002 1

003 1

003 2

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 1, 2017 5:03 PM
(912 views)

1 REPLY

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 1, 2017 5:03 PM
(913 views)