Updated: March 2, 2016
Returns the support value for a specified state.
PredictSupport(<scalar column reference>, [<predicted state>])
A scalar column.
A scalar value of the type that is specified by <scalar column reference>.
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.
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