Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

ClusterProbability (DMX)

Returns the probability that the input case belongs to the specified cluster.


          

ClusterProbability([<Node_Caption>])
        

This function can be used only if the underlying data mining model supports clustering.

A scalar value.

The following syntax uses the mining model content schema rowset to return the node captions that exist in the mining model.

SELECT NODE_CAPTION FROM <model>.CONTENT

For more information about using this syntax, see SELECT FROM <model>.CONTENT (DMX). For more information about the mining model content schema rowset, see DMSCHEMA_MINING_MODEL_CONTENT Rowset.

If a <node caption> is not specified, the function returns the probability that the input cases belong to the most likely cluster. Use the Cluster function to return the most likely cluster.

The following example returns the probability that the specified case exists in the cluster labeled Cluster 2.

SELECT
  ClusterProbability('Cluster 2')
From
  [TM Clustering]
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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.