This example shows an instance of the WhereClause class (or one of its specializations) that defines a simple condition based on a missing value. The example shown specifies that the value of the BASE variable in the ADVS dataset is not missing, which could be expressed as any of the following:
ADVS.BASE NE ''ADVS.BASE IS NOT MISSINGADVS.BASE IS NOT NULL
Note that some attributes (such as the expected level and order attributes) have been excluded from this example.
| Code Block | ||
|---|---|---|
| ||
... condition: dataset: ADVS variable: BASE comparator: NE value: |
This condition could be represented in tabular form as:
| Dataset2 | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Other conditions based on a missing value (i.e., with a comparator value of "EQ") would be represented in a similar way.