Categorical Variables - How to reference categories

Categories are referenced by separating the variable name and the category name with a dot, all of which is contained in square brackets [ ]. For example, [Gender.Male]

“!Observed” and “!Missing” can be used to reference all observations or all ‘missing’ observations for a variable:

[Gender.!Observed] and [Gender.!Missing]

!HasValue and !Value can be used to reference all observations for a variable where the observed category has a value. For example:

[Variable.!HasValue]

[Variable.!Value]

Logical Operators

A logical operator compares two operands or expressions and produces a true or false condition. There are two types of logical operators: conditional and Boolean. Conditional operators compare two values or expressions. Boolean operators connect string, numeric, or logical expressions together to determine true-false logic. You can combine Operators to create complex operators.