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]