Handling Blanks and Missing Values

Replacing blanks or missing values is a common data preparation task for data miners. CLEM provides you with a number of tools to automate blank handling. The Filler node is the most common place to work with blanks; however, the following functions can be used in any node that accepts CLEM expressions:

• @BLANK(FIELD) can be used to determine records whose values are blank for a particular field, such as Age.
• @NULL(FIELD) can be used to determine records whose values are system-missing for the specified field(s). In IBM® SPSS® Modeler, system-missing values are displayed as $null$ values.

See the topic Functions Handling Blanks and Null Values for more information.