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 SPSS Modeler, system-missing values are displayed as $null$ values.

See Functions handling blanks and null values for more information.