IDAX.CERROR - Calculate classification error

Use this stored procedure to calculate the classification error, for example, the ratio of incorrectly classified predictions. The calculation is based on the total number of predictions.

Authorization

The privileges held by the authorization ID of the statement must include the IDAX_USER role.

Syntax

IDAX.CERROR(in parameter_string varchar(32672))

Parameter descriptions

parameter_string

Mandatory one-string parameter that contains pairs of <parameter>=<value> entries that are separated by a comma.

Data type: VARCHAR(32672)

The following list shows the parameter values:

intable: Mandatory.; The name of the input table that contains the predicted values.; Data type: VARCHAR(128)
target: Mandatory.; The column of the input table that contains the predicted values.; Data type: VARCHAR(128)
id: Mandatory.; The column of the input table that identifies a unique instance ID.; Data type: VARCHAR(128)
resulttable: Mandatory.; The name of the input table that contains real values.; Data type: VARCHAR(128)
resulttarget: Optional.; The column of the input table that contains real values.; Default: class; Data type: VARCHAR(128)
resultid: Optional.; The column of the input table that identifies a unique instance ID.; Default: "ID"; Data type: VARCHAR(128)

Returned information

The classification errors as a result set.

Example

CALL IDAX.CERROR('intable=CensusIncome_income_nb_ewd, resulttable=CensusIncome_test, id=id, target=class');