104
Chapter 6
Note on Discarding Records
When using a Select node to discard records, note that syntax uses three-valued logic and
automatically includes null values in select statements. Toexclude nu ll values (system-missing)
in a select expression, you must explicitly specify this by using and not in the expression . For
example, to select and include all records where the type of prescription drug is Drug C, you
would use the following select statement:
Drug= 'drugC' and not(@NULL(Drug))
Earlier versions of excluded null values in such situations.