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 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 |
Next: Order of Operations, Previous: Relational Operators, Up: Expressions [Contents][Index]