Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
lwx228
Level VII

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

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!

2020-07-22_13-32.png

3 REPLIES 3
Highlighted
txnelson
Super User

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?

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
lwx228
Level VII

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?

Thank Jim!

Looks like can only add auxiliary columns.
Highlighted
txnelson
Super User

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?

?????
Jim
Article Labels