Conditional and Logical Functions

Stops execution of a loop completely and continues to the statement following the loop.

Choose(expr, r1, r2, r3, ..., rElse)

Break works with For and While loops, and also with For Each Row.

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.

an expression or a value.

The value whose index in the list of arguments matches expr, or the value of the last argument.

Arguments

expr

r1, r2, r3, ...

an expression or a value.

Continue()

Ends the current iteration of a loop and begins the loop at the next iteration.

For(init, while, increment, body)

Continue works with For and While loops, and also with For Each Row.

Initialization of loop control counter.

Repeats the statement(s) in the body as long as the while condition is true. Init and increment control iterations.

while

Condition for loop to continue or end. As long as the conditional statement while is true, the loop is iterated one more time. As soon as while is false, the loop is exited.

increment

Increments (or decrements) the loop counter after while is evaluated every time the loop is executed.

body

Any number of valid JSL expressions, glued together if there are more than one.

Example

mysum = 0; myprod = 1;

For( i = 1, i <= 10, i++, mysum += i; myprod *= i; );

Show( mysum, myprod );

mysum = 55;

myprod = 3628800;

For Each Row(<dt,> script)

Repeats the script on each row of the data table.

Optional positional argument: a reference to a data table. If this argument is not in the form of an assignment, then it is considered a data table expression.

Null.

Argument

script

Any valid JSL expressions.

Example

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 ) ) );

If(condition, result, condition, ..., <elseResult>)

IfMax(expr1, result1, expr2, result2, ... <all missing result>)

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.

Evaluates the first of each pair of arguments and returns the evaluation of the result expression (the second of each pair) associated with the maximum of the expressions. If more than one expression is the maximum, the first maximum is returned. If all expressions are missing and a final result is not specified, missing is returned. If all expressions are missing and a final result is specified, that final result is returned. The test expressions must evaluate to numeric values, but the result expressions can be anything.

The result expression associated with the maximum of the expressions

IfMin(expr1, result1, expr2, result2, ... <all missing result>)

Evaluates the first of each pair of arguments and returns the evaluation of the result expression (the second of each pair) associated with the minimum of the expressions. If more than one expression is the minimum, the first minimum is returned. If all expressions are missing and a final result is not specified, missing is returned. If all expressions are missing and a final result is specified, that final result is returned. The test expressions must evaluate to numeric values, but the result expressions can be anything.

The result expression associated with the minimum of the expressions

IfMZ(condition, result, condition, ..., <elseResult>)

IfV3(condition, result, condition, ..., <elseResult>)

Interpolate(x, x1, y1, x2, y2)

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

Interpolate(x, xmatrix, ymatrix)

Is Associative Array(name)

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 evaluated argument is an associative array, or 0 otherwise.

Returns 1 if the global variable, data table, or data column is undefined or holds the Empty() value, or 0 otherwise.

Is Expr(x)

Returns 1 if the evaluated argument is an expression, or 0 otherwise.

Returns 1 if the evaluated argument is a name, or 0 otherwise.

Is Namespace(namespace)

Returns 1 if the namespace argument is a namespace; returns 0 otherwise.

Is Number(x)

Returns 1 if the evaluated argument is a number or missing numeric value, or 0 otherwise.

Is Scriptable(x)

Returns 1 if the evaluated argument is a scriptable object, or 0 otherwise.

Is String(x)

Returns 1 if the evaluated argument is a string, or 0 otherwise.

Match(a, value1, result1, value2, result2, ...)

If a is equal to value1, then result1 is returned. If a is equal to value2, result2 is returned, and so on.

MatchMZ(a, value1, result1, value2, result2, ...)

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.

MatchV3(a, value1, result1, value2, result2, ...)

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

Any variable or number. The variable must have a numeric or matrix value.

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.

Argument

Notes

Mostly used for conditional statements and loop control.

1 (true) if either of or both a and b are true.

0 (false) otherwise.

Missing if either are missing.

Arguments

a, b

Any variable or number.

Notes

Mostly used for conditional statements and loop control.

Logical Or with version 3.x behavior, which treats missing values as 0.

Mostly used for conditional statements and loop control. When opening a JMP 3 data table, this function is automatically used for any Or function.

1 (true) if either of or both a and b are true.

0 (false) otherwise.

Arguments

a, b

Any variable or number.

Notes

Or() returns missing if any evaluated argument is missing. OrMZ() returns 0 if any evaluated argument is missing.

Return(<Expr1>, <Expr2>, ..., <ExprN>)