Export (0) Print
Expand All

PredictSupport

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

Community Additions

ADD
Show:
© 2014 Microsoft