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