cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
lwx228
Level VIII

How can filter all data in a category whose minimum value is greater than the specified value in a specified column?

For example, in "Big Class. JMP ", all data of minimum body "weight" greater than 80 in each age group are selected by "age" column?For JSL

2020-06-21_09-31.png

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: How can filter all data in a category whose minimum value is greater than the specified value in a specified column?

If I understand what you are asking...….you should be able to figure this out yourself

dt=current data table();

dt << select where(col min(:weight,:age) >80);
Jim

View solution in original post

3 REPLIES 3
txnelson
Super User

Re: How can filter all data in a category whose minimum value is greater than the specified value in a specified column?

If I understand what you are asking...….you should be able to figure this out yourself

dt=current data table();

dt << select where(col min(:weight,:age) >80);
Jim
lwx228
Level VIII

Re: How can filter all data in a category whose minimum value is greater than the specified value in a specified column?

Thank Jim!

Is this SQL syntax?
txnelson
Super User

Re: How can filter all data in a category whose minimum value is greater than the specified value in a specified column?

SQL does have "Select" and "Where" components of it's language, what I provided to you is a 

     Select Where()

function right out of JSL

Jim