0 / 0
Handling blanks and missing values (SPSS Modeler)

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.

Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more