Scripting Guide > Scripting Platforms > Filter by Value Using a Where Statement
Publication date: 07/08/2024

Filter by Value Using a Where Statement

You can use a Where statement to filter by a specific value. If you are adding a Where clause to a JMP script that contains column references, you must first resolve the references. The following example limits the analysis to females and fits a line on the Bivariate report.

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
Ycol = Column( "weight" );
Xcol = Column( "height" );
biv2 = dt << Bivariate(
Y( Ycol ),
X( Xcol ),
Fit Line( ),
Where( :sex == "F" ) );
Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).