Logical Operators

These operators accept any Numerical value as an operand, with zero representing false and any non-zero (including missing values) representing true. The results are always encoded as 0 or 1.

Note that the special value #Missing represents a missing value and can be used as a numerical operand in any derivation rule.

And

Numerical And(Numerical boolean1, ...)

And logical operator.

Example

Dictionary Person
{
  Categorical Name;
  Numerical Age;
  Categorical City;
  // Returns 1 if Age is less than 18 (or missing) and City is "New York", otherwise returns 0
  Numerical IsSelected1 = And(L(Age, 18), EQ(City, "New York"));
  // Returns 1 if Age is less than 18 and not missing and City is "New York", otherwise returns 0
  Numerical IsSelected2 = And(And(L(Age, 18), NEQ(Age, #Missing)), EQ(City, "New York"));
  // Returns 1 if Age is missing and City is "New York", otherwise returns 0
  Numerical IsSelected3 = And(EQ(Age, #Missing), EQ(City, "New York"));
}

Or

Numerical Or(Numerical boolean1, ...)

Or logical operator.

Example

Dictionary Person
{
  Categorical Name;
  Numerical Age;
  Categorical City;
  // Returns 1 if Age is less than 18 (or missing) or City is "New York", otherwise returns 0
  Numerical IsSelected1 = Or(L(Age, 18), EQ(City, "New York"));
  // Returns 1 if Age is less than 18 and not missing, or City is "New York", otherwise returns 0
  Numerical IsSelected2 = Or(And(L(Age, 18), NEQ(Age, #Missing)), EQ(City, "New York"));
  // Returns 1 if Age is missing or City is "New York", otherwise returns 0
  Numerical IsSelected3 = Or(EQ(Age, #Missing), EQ(City, "New York"));
}

Not

Numerical Not(Numerical boolean)

Not logical operator.