PredictSupport
Returns the support value for a specified state.
Syntax
PredictSupport(<scalar column reference>, [<predicted state>])
Applies To
A scalar column.
Return Type
A scalar value of the type that is specified by <scalar column reference>.
Remarks
If the predicted state is omitted, the state that has the highest predictable probability is used, excluding the missing states bucket. To include the missing states bucket, set the <predicted state> to INCLUDE_NULL.
To return the support for the missing states, set the <predicted state> to NULL.
Examples
The following example uses a singleton query to predict whether an individual will be a bike buyer, and also determines the support for the prediction based on the TM Decision Tree mining model.
SELECT
[Bike Buyer],
PredictSupport([Bike Buyer]) AS [Support],
From
[TM Decision Tree]
NATURAL PREDICTION JOIN
(SELECT 28 AS [Age],
'2-5 Miles' AS [Commute Distance],
'Graduate Degree' AS [Education],
0 AS [Number Cars Owned],
0 AS [Number Children At Home]) AS t
See Also
Reference
Data Mining Extensions (DMX) Function Reference
Functions (DMX)
Mapping Functions to Query Types (DMX)