Building CLEM expressions (SPSS Modeler) | IBM Cloud Pak for Data as a Service

IBM Cloud Pak for DataIBM Cloud Pak for Data

Pull0
Commit0
Push0
Checkout branch
Merge conflict
Commit history
Git preferences

Pull and push
Pull only

Export project
Import project

Analytics project
Data Transform project

JupyterLab
RStudio
Project terminal

Connected assets
Notebook
Connection
Data asset
Scheduled job
Model
FunctionBETA
Synthesized neural networkBETA
ExperimentBETA
Streams flowBETA
Modeler flow
Dashboard
Data Refinery flow
Environment
Visual recognition model
Natural language classifier model
Application

Fork Project
Export
Download

0 / 0

Confirm

Do you want to log out?

Find information

Overview
Services and integrations
Getting started and tutorials
Projects
Preparing data
Analyzing data and working with models
Deploying models and other assets
Data governance
AI governance
Troubleshooting
Administration
Glossary

Building CLEM (legacy) expressions

Last updated: Jan 17, 2024

Building CLEM expressions (SPSS Modeler)

About CLEM
The Control Language for Expression Manipulation (CLEM) is a powerful language for analyzing and manipulating the data that streams through an SPSS Modeler flow. Data miners use CLEM extensively in flow operations to perform tasks as simple as deriving profit from cost and revenue data or as complex as transforming web log data into a set of fields and records with usable information.
CLEM examples
The example expressions in this section illustrate correct syntax and the types of expressions possible with CLEM.
Values and data types
CLEM expressions are similar to formulas constructed from values, field names, operators, and functions. The simplest valid CLEM expression is a value or a field name.
Expressions and conditions
CLEM expressions can return a result (used when deriving new values).
Working with strings
There are a number of operations available for strings.
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.
Working with numbers
Numerous standard operations on numeric values are available in SPSS Modeler.
Working with times and dates
Time and date formats may vary depending on your data source and locale. The formats of date and time are specific to each flow and are set in the flow properties.
Summarizing multiple fields
The CLEM language includes a number of functions that return summary statistics across multiple fields.
Working with multiple-response data
You can analyze multiple-response data using a number of comparison functions.
The Expression Builder
You can type CLEM expressions manually or use the Expression Builder, which displays a complete list of CLEM functions and operators as well as data fields from the current flow, allowing you to quickly build expressions without memorizing the exact names of fields or functions.
Find
In the Expression Builder, you can search for fields, values, or functions.

Parent topic: CLEM (legacy) language reference

Focus sentinel

Focus sentinel

Focus sentinel

Focus sentinel

Focus sentinel

Focus sentinel

Contact IBM Terms of Use Privacy Accessibility