ISMEMBER

The values to test if they members of a table. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. If data contains more than one column, all columns must be the same data type (either numeric or text strings). For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your IBM® product.

table

The table values to compare against. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. If table contains more than one column, all columns must be the same data type as data (either numeric or text strings). The number of data values in table cannot exceed 16 million. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your IBM® product.

ISMEMBER differs from IN because ISMEMBER is computed on the server while IN is performed on the database whenever possible.

Description

ISMEMBER compares the data values in the specified data range to a table of data values. It returns one new column for each input column in data, each containing a one if the corresponding input value is a member of table, else a zero.

Examples

TEMP = ISMEMBER(25, COLUMN(1...10))

Creates a new column named TEMP containing the value zero.

TEMP = ISMEMBER("cat", COLUMN("cat", "dog", "bird"))

Creates a new column named TEMP containing the value one.

TEMP = ISMEMBER(V1, V1)

Creates a new column named TEMP containing all ones.

TEMP = ISMEMBER(V1, V2)

Creates a new column named TEMP, where each value is a one if the corresponding row of column V1 contains a value in column V2, else a zero.

TEMP = ISMEMBER(V1:V2, V5:V10)

Creates two new columns named TEMP and VX. The column TEMP contains a one if the corresponding row of column V1 is a member of columns V5 - V10, else a zero. The column VX P contains a one if the corresponding row of column V2 is a member of columns V5 - V10, else a zero.

TEMP = ISMEMBER(V1[10:15]:V2, V3[1:100]:V6)

Creates two new columns named TEMP and VX, each with values in rows 1-6 (the other cells are empty). The values in column TEMP are one if the contents of rows 10-15 of column V1 are members of rows 1-100 of columns V3 - V6. The values in column VX are one if the contents of rows 10-15 of column V2 are members of rows 1-100 of columns V3 - V6.

Related Functions

Function	Description
ISEVEN	Tests if input values are even (that is, divisible by two)
ISODD	Tests if input values are odd (that is, not divisible by two).