Transformation Expressions

Transformation expressions are used in commands such as COMPUTE, IF, DO IF, LOOP IF, and SELECT IF.

Release history

Release 13.0

• APPLYMODEL and STRAPPLYMODEL functions introduced.
• DATEDIFF and DATESUM functions introduced.

Release 14.0

• REPLACE function introduced.
• VALUELABEL function introduced.

Release 16.0

• CHAR.INDEX function introduced.
• CHAR.LENGTH function introduced.
• CHAR.LPAD function introduced.
• CHAR.MBLEN function introduced.
• CHAR.RINDEX function introduced.
• CHAR.RPAD function introduced.
• CHAR.SUBSTR function introduced.
• NORMALIZE function introduced.
• NTRIM function introduced.
• STRUNC function introduced.

Release 17.0

• MEDIAN function introduced.
• mult and fuzzbits arguments introduced for the RND and TRUNC functions.
• NEIGHBOR and DISTANCE functions added to APPLYMODEL and STRAPPLYMODEL.