Define Recode Scheme

Define a recode scheme for the selected attribute. A recode scheme consists of one or more recode definitions.

Note: Oracle Data Miner does not allow you to define recode schemes for attributes with with more than 2000 distinct values.

Recode schemes are defined one attribute at a time. To define a recode scheme for an attribute, select it and click Define.

To specify a recode definition:

To delete a definition, select it in the listbox, and click Delete.

You cannot edit existing definitions. To change a definition, delete it and create a new definition.

You can recode single values, NULL values, ranges of values, and Other values. For single values and ranges of values, you can pick the values from the dropdown that has been populated with all possible attribute values, or you can enter new values that have a compatible datatype. The new or recode value can have a different datatype from the old value (for example, you could recode 0 as the one character y).

Recode definitions are sorted in the following order in the listbox: NULL values (first), single values, ranges of values, and Other values last.

If the wizard detects problems when you are defining a recode scheme, it generates a message explaining the problem.

Note:The Recode Wizard supports the relational operators =, <=, and >=. This makes it difficult to partition values at a particular numerical value (example: Income <= 100000 vs. Income > 100000). Recode is really meant for use with strings and integers; use Discretization to accomplish the same purpose for real numbers.

Click OK when you have finished defining the recode scheme for the selected attribute.