How do get the position by fuzzy matching?

Question

dt=Open("$SAMPLE_DATA\Big Class.jmp");
dt<<Sort(By(4),Order(Ascending),replace table);

In ascending order of height, how do I get the row number of a value that does not appear in the height column that is closest to the height less than this value in the height column?

For example, this value is 54.

Thanks!

Craige_Hales · Accepted Answer

This might work, but LocSorted has some edge cases, especially at the lower end, that might make it hard to use. Read the doc and decide what you need to do for the too-small and too-big case. I think it might always return the first row of the set of values, but that isn't documented.  @XanGregg

dt=Open("$SAMPLE_DATA\Big Class.jmp");
dt<<Sort(By(4),Order(Ascending),replace table);
vector = dt:height<<getasmatrix;
position = loc sorted(vector,[54])[1];
show(dt[position,0]);

dt[position,0] = {"LILLIE", 12, "F", 52, 64};