This example shows an instance of the WhereClause class (or one of its specializations) that defines a simple condition based on a missing single specified selection value. The example shown specifies that the value of the BASE SAFFL variable in the ADVS ADSL dataset is not missingequal to "Y", which could be expressed as any of the following:
ADVSADSL.BASE NE SAFFL EQ 'Y'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: ADVSADSL variable: BASESAFFL comparator: NEEQ value: - Y |
This condition could be represented in tabular form as:
| Dataset2 | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Other conditions based on a missing single value (i.e., with a comparator value of "EQ", "NE", "LT", "LE", "GT", or "GE") would be represented in a similar way.