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

- JMP User Community
- :
- Discussions
- :
- How can the minimum value of the specified column corresponding to each category...

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

Highlighted
##
How can the minimum value of the specified column corresponding to each category be greater than the number of categories of a certain value?

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

Jul 21, 2020 10:47 PM
(278 views)

For example, according to "Big class.jMP"

1. First, categorize by age.

2. Determine the minimum "weight" >90 for each age.

3. Figure out the number of age categories that meet the second condition.

So it turns out the number of ages is 3.

How can I use JSL to solve it quickly?Thanks!

3 REPLIES 3

Highlighted
##
Re: How can the minimum value of the specified column corresponding to each category be greater than the number of categories of a certain value?

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

Create a new column that has the categories you want. Then use Tables==>Summary to calculate the statistics. First generate the minimum for age, grouped by the binning column. Then to get the counts, the the Summary platform again, but this time group by both Age and the binning column.

Jim

Highlighted
##
Re: How can the minimum value of the specified column corresponding to each category be greater than the number of categories of a certain value?

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

Thank Jim!

Looks like can only add auxiliary columns.

Looks like can only add auxiliary columns.

Highlighted
##
Re: How can the minimum value of the specified column corresponding to each category be greater than the number of categories of a certain value?

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

?????

Jim