Logical Condition on Numeric Values

Expressions Defining Numeric Conditions

DataTile provides an intuitive expression syntax to define a numeric condition that is considered True when satisfied.

These expressions are used in many places across the platform:

• Definition of a dichotomous multi-response set.

• Segmentation of numeric variables.

• Logical node ANY in the Logical Expression Builder ANY(expression).

• Codebook.

• etc.

Syntax

• A single number is a trivial condition assumed to be true when the variable is equal to the given value.

• >=9 is true for all values 9 or greater.

• 1_6 or 1:6 denotes the inclusive interval from 1 to 6. Underscore and colon notations are equivalent, but underscore avoids incorrect casting to a time interval in Excel.

• * stands for ANY non-missing value. This expression is not relevant in some contexts.

You can combine expressions by separating them with commas.
For example, '1, 3, 11_15, >=20' evaluates to true if the value equals 1 or 3, lies between 11 and 15 inclusively, or is 20 or greater.