How to select rows based upon multiple conditions using a JMP® script

[#1]

Overview

The following examples demonstrate how you can use the logical AND (&) and OR (|) operators with the Select Where message to select rows that meet multiple conditions.

Instructions

In a JMP® session, click the File menu and select New ► Script. Copy the below script and paste it into the script window. To run the sample script, click the Edit menu and select Run Script.

/* Open a sample data table */ 
dt = Open( "$SAMPLE_DATA\Big Class.jmp" ); 

/* Select rows where students are over 13, who are also less than 65 inches tall */ 
dt << Select Where( :age > 13 & :height < 65 );

Wait( 2 ); // For demonstration purposes 
dt << Clear Select; // For demonstration purposes 

/* Select rows where students are either 12 or 14 years old */ 
dt << Select Where( :age == 12 | :age == 14 ); 

Additional Documentation

More information about the JMP Scripting Language can be found in the Scripting Guide available in the online help.

[Previously JMP Note 49517]