Click or drag to resize

IMcOMGlobalMcIsMissingValue Method

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

Namespace:  MediaCy.IQL.ObjectManager
Assembly:  MediaCy.IQL.ObjectManager (in MediaCy.IQL.ObjectManager.dll) Version: 10.0.6912.0
Syntax
VB
Copy
Function McIsMissingValue ( 
	ValueToTest As Object
) As Boolean

Parameters

ValueToTest
Type: SystemObject
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.

Return Value

Type: Boolean
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.
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.
Examples
VB
Copy
Dim moT As McObject, modMiss As McObject, mofMiss As McObject
Set modMiss = McObjectTemp(McMissingDouble)
Set mofMiss = McObjectTemp(McMissingSingle)
Results.Text = "This is a missing Double: " & McMissingDouble & " Is Missing? " & McIsMissingValue(McMissingDouble) & vbCrlf & _
"This is a missing Single: " & McMissingSingle & " Is Missing? " & McIsMissingValue(mofMiss)
Set moT = McObjectTemp(Array(1#, 3#, 5#, 7#))
moT.SelectedValues(Array(1, 2)) = mofMiss 'set two values to missing
Results.Text = Results.Text & vbCrlf & "Vector w/missing: " & McToText(moT)
Results.Text = Results.Text & vbCrlf & "Is Missing: " & McToText(McOpEQ(moT, modMiss))
Results.Text = Results.Text & vbCrlf & "Is Not Missing: " & McToText(McOpNE(moT, modMiss))
Results.Text = Results.Text & vbCrlf & "Any Missing in the array: " & McIsMissingValue(moT)
See Also