Next: Order of Operations, Previous: Relational Operators, Up: Expressions [Contents][Index]

PSPP functions provide mathematical abilities above and beyond those possible using simple operators. Functions have a common syntax: each is composed of a function name followed by a left parenthesis, one or more arguments, and a right parenthesis.

Function names are not reserved. Their names are specially treated
only when followed by a left parenthesis, so that ‘`EXP(10)`’
refers to the constant value *e* raised to the 10th power, but
‘`EXP`’ by itself refers to the value of a variable called `EXP`

.

The sections below describe each function in detail.

• Mathematics: | EXP LG10 LN LNGAMMA SQRT | |

• Miscellaneous Mathematics: | ABS MOD MOD10 RND TRUNC | |

• Trigonometry: | ACOS ARCOS ARSIN ARTAN ASIN ATAN COS SIN TAN | |

• Missing Value Functions: | MISSING NMISS NVALID SYSMIS VALUE | |

• Set Membership: | ANY RANGE | |

• Statistical Functions: | CFVAR MAX MEAN MEDIAN MIN SD SUM VARIANCE | |

• String Functions: | CONCAT INDEX LENGTH LOWER LPAD LTRIM NUMBER REPLACE RINDEX RPAD RTRIM STRING STRUNC SUBSTR UPCASE | |

• Time and Date: | CTIME.xxx DATE.xxx TIME.xxx XDATE.xxx DATEDIFF DATESUM | |

• Miscellaneous Functions: | LAG YRMODA VALUELABEL | |

• Statistical Distribution Functions: | PDF CDF SIG IDF RV NPDF NCDF |

Next: Order of Operations, Previous: Relational Operators, Up: Expressions [Contents][Index]