Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)