More than two arguments can be strung together. a&b returns 1 (true) only if all arguments evaluate to true.
Logical And with JMP 3 behavior, which treats missing values as 0.
More than two arguments can be strung together. a:&b returns 1 (true) only if all arguments evaluate to true. When opening a JMP 3 data table, this function is automatically used for any And function.
Evaluates expr. If the value of expr is 1, r1 is returned; if 2, the value of r2 is returned, and so on. If no matches are found, the last argument (rElse) is returned.
The value whose index in the list of arguments matches expr, or the value of the last argument.
Repeats the statement(s) in the body as long as the while condition is true. Init and increment control iterations.
mysum = 0; myprod = 1;
For( i = 1, i <= 10, i++, mysum += i; myprod *= i; );
Show( mysum, myprod );
mysum = 55;
myprod = 3628800;
Repeats the script on each row of the data table.
The following example creates data table references and then iterates over each row in Big Class.jmp. If the value of age in a row is greater than 15, the age is printed to the log.
dt1 = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt2 = Open( "$SAMPLE_DATA/San Francisco Crime.jmp" );
For Each Row( dt1, If( :age > 15, Show( :age ) ) );
Returns result when condition evaluates true. Otherwise returns next result when that condition evaluates as true. The optional elseResult is used if none of the preceding conditions are true. If no elseResult is given, and none of the conditions are true, then nothing happens.
Logical If with version 3.x behavior, which treats missing values as 0; used automatically when opening v3 data tables.
Linearly interpolates the y-value corresponding to a given x-value between two points (x1, y1), and (x2, y2) or by matrices xmatrix and ymatrix. The points must be in ascending order.
Returns 1 if the global variable, data table, or data column does not have a value (is uninitialized), or 0 otherwise.
If a is equal to value1, then result1 is returned. If a is equal to value2, result2 is returned, and so on.
Match with version 3.x behavior, which treats missing values as 0; used automatically when opening v3 data tables.
0 (false) if a>0.
1 (true) if a<=0.
Missing value if a is missing.
a, b
Logical Or with version 3.x behavior, which treats missing values as 0.
a, b
Or() returns missing if any evaluated argument is missing. OrMZ() returns 0 if any evaluated argument is missing.
Returns the y argument corresponding to the largest x argument that is less than or equal to x0. The x points must be specified in ascending order.
Repeatedly tests the expr condition and executes the body until the expr condition is no longer true.
Returns 1 if expr yields a missing value or zero, 0 otherwise.