DECIMATE

Syntax

DECIMATE(column, max_value)

Parameters

column

The column of values to decimate. All values within this column must be positive integers less than max_value.

max_value

The number of columns to return. This must be a positive integer greater than or equal to the maximum value in column.

Description

DECIMATE converts a positive integer value into a binary pattern of max_value columns in length. If the value is n, then-th column contains a one; all other columns contain zeros. This macro function returns max_value columns.

DECIMATE is the opposite of the MAXINDEX macro function.

Examples

TEMP = DECIMATE(COLUMN(1,2,3), 3)

Creates new columns named TEMP, VX, and VY with a row for each corresponding row of input. The first row contains 1 0 0, the second contains 0 1 0, and the third contains 0 0 1.

TEMP = DECIMATE(COLUMN(1,1,2), 3)

Creates new columns named TEMP, VX, and VY with a row for each corresponding row of input. The first row contains 1 0 0, the second contains 1 0 0, and the third contains 0 1 0.

TEMP = DECIMATE(V1, 10)

Creates ten new columns with a row for each corresponding row of input. Each row contains a single one in the column representing the corresponding input value. All other columns contain zeros.

Related Functions

Function	Description
MAX	Computes the maximum of a range of cells
MAXINDEX	Returns the input columns values lagging by a specified number of time steps
MIN	Computes the minimum of a range of cells