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]