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.

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

For Each Row( dt, 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 is undefined or holds the Empty() value, 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.

The Match() function explicitly checks to see if the compare expression x is missing and if the value of value1 is missing, then it returns the value of result1; otherwise it continues to compare the expression x to each valueN value in each valueN/resultN pair, ignoring any missing values. If the expression x is equal to any of the valueN value, then the corresponding resultN value is returned. If no matching valueN value is found, then the resultElse value is returned.

Match with version 3.x behavior, which treats missing values as 0; used automatically when opening v3 data tables.

The MatchMZ() function explicitly checks to see if the compare expression x is missing and if the value of value1 is missing, then it returns the value of result1; otherwise it continues to compare the expression x to each valueN value in each valueN/resultN pair, ignoring any missing values. If the expression x is equal to any of the valueN value, then the corresponding resultN value is returned. If no matching valueN value is found, then the resultElse value is returned.

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.

This example returns the evaluation of both expressions in the Return() function as a list. The Return() function can have more than one argument. If only one is present, then the value of the expression is returned. If more than one is present, then the values of all the expressions is returned in a list.

f = Function( {a, b},

Return( a - b, a + b )

);

{lo, hi} = f( 10, 1 );

`Show( lo, hi );`

Show( f( 7, 15 ) );

lo = 9;

hi = 11;

f(7, 15) = {-8, 22};

Return() not enclosed by a function, method, or recursive function call causes an error.

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.