overview
The following example shows how to use the logical AND (&) and logical OR (|) operators with the Select Where message to select rows that meet multiple conditions.
procedure
In a JMP session, click the File menu and select New > Script (or JSL Script in JMP 18). Copy the script below and paste it into the script window. To run the example script, click the Edit menu and select Run Script.
dt = Open( "$SAMPLE_DATA\Big Class.jmp" );
dt << Select Where( :age > 13 & :height < 65 );
Wait( 2 );
dt << Clear Select;
dt << Select Where( :age == 12 | :age == 14 );
Additional Documentation
For more information about the JMP scripting language, see the Scripting Guide available in the online help .
Note: This FAQ is based on the following JMP Note:
JMP Note 575404 - How to select rows based upon multiple conditions using a JMP script