Built-in functions
 PMML3.2 Menu Home PMML Notice and License Changes Conformance Interoperability General Structure Header Data Dictionary Mining Schema Transformations Statistics Taxomony Targets Output Functions Built-in Functions Model Composition Model Verification Association Rules Cluster Models General Regression Naive Bayes Neural Network Regression Ruleset Sequences Text Models Trees Vector Machine

## PMML 3.2 - Built-in functions

Almost all programming languages come with a set of predefined functions that perform low-level operations. PMML has a similar set of functions.

The definitions of functions in PMML generally follow the design of functions and operators in XQuery. Further ideas are taken from MathML , XPath, , Java Date formats .

### +, -, * and /

Functions for simple arithmetics.

Pseudo-declaration of PMML built-in function +:

 ... implementation built-in ...
The functions -, *, and / are defined in the same way and have two parameters.

Example: Return the difference between input fields named A, B.


Assuming A=2.5 and B=4 the result corresponding to this Apply element is -1.5. Note: If one of the input fields of a simple arithmentic function is a missing value, the result evaluates to missing value.

### min, max, sum and avg

Returns an aggregation of a variable number of input fields.

Pseudo-declaration of PMML built-in function min:

 The function takes a variable number of as parameters ... implementation built-in ...
The aggregation functions max, sum, and avg are defined in the same way. Note that the number of input parameters is variable but these functions do not aggregate values coming from multiple input records.

Example: Return the minimum value of input fields named A, B, and C.


Assuming A=2.5 and B=4 and C=1.5 the result corresponding to this Apply element is 1.5. Missing values in the input to an aggregate function are simply ignored. It should be noted that this has an effect on how avg is computed in particular. In the above example, if B is a missing value, the result corresponding to applying avg on A, B and C is 2.

### log10, ln, sqrt, abs, exp, pow, threshold, floor, ceil, round

Further mathematical functions.

Pseudo-declaration of PMML built-in function log10:

 ... implementation built-in ...
The function log10 returns the logarithm to the base 10. The functions ln (natural log), sqrt (square root), abs (absolute value), exp (exponential) are defined in the same way. Semantics are as usual. See also MathML.

Example: Return the logarithm to the base 10 of an input field A.


Assuming A=2.5 the result corresponding to this Apply element is approx. 0.397940008672038.

Pseudo-declaration of PMML built-in functions pow and floor:

 ... implementation built-in ... ... implementation built-in ...
The function pow(x,y) returns the number x raised to the power y, threshold(x,y) returns 1 if x>y and 0 otherwise. Functions floor, ceil, round return an integer obtained by rounding the numeric argument down, up, and to the closest integer respectively. See section on respective functionality in Targets for examples.

Example: Return the cube of an input field A.

 3
Assuming A=5.0 the result corresponding to this Apply element is 125.0.

### uppercase

Returns a string where all lowercase characters in the input string are replaced by their uppercase variants.

Pseudo-declaration of PMML built-in function uppercase:

 ... implementation built-in ...
The function uppercase uses the Unicode definitions for classifying characters as uppercase / lowercase. See XQuery fn:upper-case

Example: Return the field Str with all characters in upper case.


Assuming Str="aBc9" the result corresponding to this Apply element is "ABC9".

### substring

Extracts a substring from an input string.

Pseudo-declaration of PMML built-in function substring:

 ... See XQuery fn:substring ...
startPos and length must be positive integers. The first character of a string is located at position 1 (not position 0).

Example: Return the 3 characters of field Str beginning at position 2.

 2 3
Assuming Str="aBc9x" the result corresponding to this Apply element is "Bc9".

### trimBlanks

Returns a string where leading and trailing characters in the input string are removed. Note that trailing blanks in PMML, by definition, are not significant when strings are compared.

Pseudo-declaration of PMML built-in function trimBlanks:

 ... implementation built-in ...
Blanks include tab and newline characters. Use definitions according to Unicode.

Example: Trim blanks of field Str.


Assuming Str=" aBc9x " the result corresponding to this Apply element is "aBc9x".

### formatNumber

Formats numbers according to a pattern. The pattern uses the Posix descriptors as used, e.g., in the C function printf.

Pseudo-declaration of PMML built-in function formatNumber:

 ... implementation built-in ...

Example: Convert a number in the field Num into a string of length 3 with leading blanks.

 %3d
Assuming Num=2 the result corresponding to this Apply element is the string " 2".

### formatDatetime

Formats date and time value according to a pattern. The pattern is a Posix descriptors as used, e.g., in the C function strftime or the Unix command date. See, e.g., Posix datetime descriptors

Pseudo-declaration of PMML built-in function formatDatetime:

 ... implementation built-in ...
input must be a date or time or dateTime.

Example: Format a date value as 'Month/Day/Year'.

 %m/%d/%y
With StartDate being the date August 20th, 2004 the result is StartDateUS="08/20/04".

### dateDaysSinceYear

Function for transforming dates into integers. The type dateDaysSinceYear is a variant of the type date where the values are represented as the number of days since Year-01-01. The date January 1 of Year is represented by the number 0. January 2 of Year is represented by 1, February 1 of Year is represented by 31, etc. Dates before January 1 of Year are represented as negative numbers. For example, values of type dateDaysSince[1960] are the number of days since January 1, 1960. The date January 1, 1960 is represented by the number 0.
For example, the date April 1, 2003 can be converted to the value 15796 of type dateDaysSince[1960].

Pseudo-declaration of PMML built-in function dateDaysSinceYear:


input must be of datatype date or dateTime.

Example: Calculate days since 1970.

 1970

### dateSecondsSinceYear

Function for transforming dates into integers. The type dateSecondsSinceYear is a variant of the type date where the values are represented as the number of seconds since midnight starting the first day of Year (which is represented by 0). 1 minute after midnight on January 1 of Year is represented by 60, 1 hour after midnight on January 1 of Year is represented by 3600, etc. Times before January 1 of Year are represented as negative numbers.
For example, values of type dateSecondsSince[1960] are the number of seconds since the midnight starting January 1, 1960. 30 minutes and 3 seconds after 3 o'clock in the morning of January 3, 1960 can be converted to the value 185403 of type dateSecondsSince[1960].

Pseudo-declaration of PMML built-in function dateSecondsSinceYear:


input must be of datatype date or dateTime. If input is of datatype date, it is assumed that the time is 00:00:00 at this date.

Example: Create a new field PurchaseDateSeconds from the PurchaseDate attribute relative to the year 1970.

 1970

### dateSecondsSinceMidnight

Function for transforming dates into integers. For example, Midnight returns a value of 0, 1 second after midnight (00:00:01) would return a value of 1, one minute after midnight would return a value of 60, etc. 23 minutes and 30 seconds after 5 o'clock in the morning should return 19410.

Pseudo-declaration of PMML built-in function dateSecondsSinceMidnight:


input must be of datatype time or dateTime.

Example: Create a new field PurchaseDateSeconds from the PurchaseDate attribute relative to midnight.



 e-mail info at dmg.org