7.7 Functions
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 |