JMP Scoring CodeMy company just purchased JMP and currently using it to build models...Just have a question. Basically we don't have SAS base, we only have SQL Server..
I have built a Decision Tree model and would like to score fresh data. JMP creates a sas scoring code but as I mentioned my company doesn't have any SAS base or EG..
I have 2 questions :
1) Can the SAS scoring code be translated into SQL code by JMP
2) If the above is not possible, can I import into JMP a new dataset that I want to score, and score it with this scoring code??
Many Thanks
Re: JMP Scoring CodeThere is a previous thread about creating deciles.
I think the best solution might be a formula column such as this:
Ceiling( (Col Rank( :weight ) / Col Number( :weight )) * 10 )
(see attached BIg Class example).
Re: JMP Scoring CodeI use this add-in to create bins...
https://community.jmp.com/t5/JMP-Add-Ins/Interactive-Binning/ta-p/22434
Re: JMP Scoring CodeThank You Karen! I have managed to copy the formula and it work well..
Now, I have another question. How do you create deciles in simple JMP? I
don't have JMP Pro...I've heard with JMP Pro you can use the interactive
binning but don't have the Pro
Cheers
Alice
Re: JMP Scoring CodeHello,
So to get going on scoring models you could look at the Formula Depot to learn about getting formulas/scoring code out of JMP. The code that JMP generates may not get you 100% of the way to what you need but hopefullly it can get you most of the way there.
file:///Applications/JMP%20Pro%2014.app/Contents/Resources/en.lproj/JMPHelp/index.html#page/jmp%2FPSM_Formula_Depot.html%23
You can also use the formula depot to move the "scoring code" (which is just a column function) from one JMP data table to another. There are other options for copying a formula from one table to anohter.
To learn more about JMP formulas see:
file:///Applications/JMP%20Pro%2014.app/Contents/Resources/en.lproj/JMPHelp/index.html#page/jmp%2FUG_FormulaEditor.html%23
