cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
natalie_
Level V

Select a range of rows with variables

Hi everyone,

Is it possible to select a range of rows with variables?

This is what I have, but it found the maximum over the entire range:

vlower = lowerVoltage << get;

  vupper = upperVoltage << get;

  row1 = (vlower/10)+1;

  row2=(vupper/10)+1;

select_rows = row1::row2(dt2);          

select_values = dt2:Idoff(select_rows);

id = maximum(select_values);



2 REPLIES 2
txnelson
Super User

Re: Select a range of rows with variables

Natalie,

If I understand what you are asking for, I believe the jsl you want would be:

vlower = lowerVoltage << get;

  vupper = upperVoltage << get;

  row1 = (vlower/10)+1;

  row2=(vupper/10)+1;

select_rows = row1:row2;

id = maximum(dt2:Idoff[select_rows]);

dt<<select rows(select_rows);

Jim
natalie_
Level V

Re: Select a range of rows with variables

Thank you, so simple!   Thank you for helping me with more JSL syntax!

Recommended Articles