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.