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 MIN SD SUM VARIANCE|
|• String Functions:||CONCAT INDEX LENGTH LOWER LPAD LTRIM NUMBER RINDEX RPAD RTRIM STRING 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|