I am trying to build a decision tree algorithm with multiple regressors. I am having trouble changing the properties for the input variables to regressors (the only multiple flag choice is "not null"). I created a mining model using the DMX query thinking I could change the code to include multiple regressors, however I get a syntax error when trying to execute the model. Also, I am wondering if you can view the dmx code for a model built using the mining wizard.
My query is as follows:
CREATE MINING MODEL BVRSlotq1052
(Machine Long Key,
[Banksize] LONG CONTINUOUS REGRESSOR ,
[Cabinet] Text Discrete,
[CUID] Long Continuous PREDICT_ONLY,
[Denom] Text Discrete,
[Gametype] Text Discrete,
[Max Coins] Text Discrete,
[Par] Long Continuous,
[Pos] Text Discrete,
[Progressive] Text Discrete,
[Type]Text Discrete)
Using Microsoft_Decision_Trees
You need to change the one line to
[Banksize] LONG REGRESSOR CONTINUOUS ,
That is, putting REGRESSOR before CONTINUOUS.
The following tip shows a sproc for generating a CREATE MINING MODEL statement from a server model
http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/3352.aspx
This tip shows a sproc for generating CREATE MINING STRUCTURE and ALTER statements for server structures
http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/3652.aspx
|||thanks!
No comments:
Post a Comment