Description

Tests a value or array to see if a value is missing

Return Type

A Boolean value.  

True if ValueToTest is a Single or Double type, and any element of ValueToTest is the special missing value (as generated by the McMissingSingle or McMissingDouble methods). A zero-length ValueToTest array will return False.

Syntax

object.McIsMissingValue (ValueToTest)

The McIsMissingValue Method syntax has these parts:

PartDescription
objectAn expression evaluating to an object of type McOMGlobal.
ValueToTestRequired. A Variant value.

A scalar or array of values to be tested for one or more missing values. The supplied variant may be of any type, but only Single or Double types have a special missing value.

Remarks

Missing values are generated by the McMissingSingle or McMissingDouble methods. The McOpEQ and McOpNE logical operators also properly test for missing (or not missing) values, and those operators will return a selector identifying which elements are missing (or not missing).

The McMin, McMax, McSum operations and the statistical methods McBasicStatistics and McRankedValues will automatically exclude missing values, so you do not need to remove them from your data arrays before calling those methods. Similarly, all of the McOpWhatever vector operators will skip over missing values in the vectors that they operate on.