Last updated: Jan 17, 2024
This section covers CLEM datatypes.
CLEM datatypes can be made up of any of the following:
- Integers
- Reals
- Characters
- Strings
- Lists
- Fields
- Date/Time
Rules for quoting
Although SPSS Modeler is flexible when you're determining the fields, values, parameters, and strings used in a CLEM expression, the following general rules provide a list of best practices to use in creating expressions:
- Strings: Always use double quotes when writing strings, such as
"Type 2". Single quotes can be used instead but at the risk of confusion with quoted fields. - Fields: Use single quotes only where necessary to enclose spaces or
other special characters, such as
'Order Number'. Fields that are quoted but undefined in the data set will be misread as strings. - Parameters: Always use single quotes when using parameters, such as
'$P-threshold'. - Characters: Always use single backquotes (
`), such asstripchar(`d`, "drugA").
See Values and data types for more information. Additionally, these rules are covered in more detail in other portions of this guide.