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