Define Quantile Variables dialog

To create a quantile variable, use this dialog to select the required column(s) for deriving the quantiles. You can define quantile variables from the Variable property dialog.

Option Description
Use approximation for average ascend (faster) Approximates the bin values for a faster, but not as accurate, binning process.
Column Name From the drop-down list box, select a column from the dataset from which to derive the quantile variable column.
Quantile Type From the drop-down list box, specify the type of quantile variable column to create.
  • Select Customize to define the values manually that correspond to each quantile bin.
  • Select Average Ascend to divide the original column value range automatically across the specified number of bins.

For categorical data (for example, text or dates), and for data sources that do not support NTILE, only the Customize type is available.

Create New
  • Specify true to create a new column for the chosen variable in the output dataset.
  • Specify false to replace the original column with the variable in the output dataset.
Number of Bins Available for Quantile TypeAverage Ascend only. Specify the number of bins in the quantile column.

A bin is defined by a value range. Each bin is assigned with a bin number, incremented numerically beginning with 1. When the value of a data row for the original column falls in a certain bin value range, the quantile column is assigned the corresponding bin number.

Edit Bins Available for Quantile Type Customize only. Click to display the dialog to define the bins manually.

For numerical columns:

  • Select Use Range to define the start value (inclusive) and end value (exclusive) of the range. The end value must be larger than the start value. Ranges cannot overlap.
  • Clear Use Range to provide individual, comma-separated values for a bin.

For Date, Time, and Timestamp data types, define the start date (inclusive) and end date (exclusive) for each bin.

For a text data type, define the values to include in each bin. If the input table already exists, click available values to display the possible values.

Create Adds a row for specifying an additional quantile variable.
Delete Deletes the quantile variable in the corresponding row.