IDAX.NUMERIC_SUMMARY - Calculate summary statistics

Use this stored procedure to calculate summary statistics for numeric columns. You get information about the missing value count, non-missing value count, average, standard deviation, skewness, standard deviation of skewness, minimum, and maximum of the input columns. Null values are counted but are not part of the statistics computation.

Authorization

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

Syntax

IDAX.NUMERIC_SUMMARY (in intable VARCHAR(261), in incolumn VARCHAR(32000), in validitypredicates VARCHAR(32000))

Details

The statistics that are collected are as follows:

  • The number of valid values
  • The number of missing or invalid values
  • The minimum value
  • The maximum value
  • The standard deviation of the column
  • The skewness of the column
  • The standard deviation of the skewness of the column

Parameter descriptions

intable
Mandatory.
The name of the input table.
Data type: VARCHAR(261)
incolumn
Optional.
The numeric column of the input table.
The columns of the input table that are separated by a semicolon (;).
If this parameter is not specified, statistics for all columns of the input table are collected.
Default: NULL
Data type: VARCHAR(3200)
validitypredicates
Optional.
The semicolon-separated list of predicates to be applied on each row to determine the validity of the corresponding column value.
The list of predicates that are applied to each row to determine the validity of the value of the corresponding column.
The predicates are separated by a semicolon.
The predicates and the column names are listed in the same order.
If a predicate is empty, all non-null values of the corresponding column are valid.
If the validitypredicates parameter is set to NULL, all non-null values of all columns are valid.
Default: NULL
Data type: VARCHAR(3200)

Returned information

A table that contains the statistics that are collected for each column.

Example

CALL IDAX.NUMERIC_SUMMARY('GOSALES.ORDER_DETAILS', 'QUANTITY;UNIT_COST;UNIT_PRICE;UNIT_SALE_PRICE', null);