Groups | Blog | Home
all groups > sql server data mining > november 2003 >

sql server data mining : PredictProbability function


John Sandiford
11/4/2003 3:02:02 AM
Hi,
I'm using the SQL like syntax for Data Mining and would
like to output a prediction and the associated
probability, so initially I thought I would use Predict
([A}), PredictProbability([A]).
The Predict function by default excludes NULL values which
is what I want, however the PredictProbability function
doesn't appear to have an option to INCLUDE_NULL, or
EXCLUDE_NULL. So do I have to resort to PredictHistogram
([A]) and extract the relevant information?

Many thanks for all your previous help - it has been
extreemly useful

John Sandiford
11/4/2003 4:07:54 AM
It appears that the PredictProbability function assumes
EXCLUDE_NULL, which is fine for my current scenario. If I
wanted the PredictProbability to include 'null values as
valid predictions' presumably I couldn't use this
function ?

Peter Kim [MS]
11/4/2003 3:10:35 PM
You should be able to do PredictProbability(Predict(col, INCLUDE_NULL)). As
you see, Predict(col) is not just a function, but also it could be used as
replacement of col-ref to modify prediction behavior. Say, the same is true
for PredictSupport(), PredictHistogram().

--
Peter Kim
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

John Sandiford
11/5/2003 1:14:20 AM
Thanks Peter, that is a great help
AddThis Social Bookmark Button