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

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

lwx228 — Fri, 09 Jun 2023 23:29:51 GMT

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

Thanks!

txnelson — Mon, 22 Jun 2020 05:46:55 GMT

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);

lwx228 — Mon, 22 Jun 2020 06:42:04 GMT

Thank Jim!

Is this SQL syntax?

txnelson — Mon, 22 Jun 2020 10:42:56 GMT

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