nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

15948_en-US

liliconcom

Best practices for deploying a JMP model into a SQL database environment?

I have a customer that is interested in learning what others might be doing wrt to deploying models created in JMP Pro, typically decision trees or bootstrap forest generated into their database architecture. Any thoughts?

Re: Best practices for deploying a JMP model into a SQL database environment?

This customer often uses Bootstrap Forest, Decision Trees, and logistic regression...when you say 'it doesn't work for everything' any thoughts on known failure modes for these specific models/platforms?

Re: Best practices for deploying a JMP model into a SQL database environment?

Yes, chris.kirchberg, great point! The Partition platform and Neural platform generate SAS Data Step ready for model manager. The As SAS Expr (); works for other models where we don't generate the SAS data step directly.

10655_Screen Shot 2015-12-15 at 5.33.37 PM.png

For example -- SAS code for a Adaptive Elastic Net model:

10656_Screen Shot 2015-12-15 at 5.37.01 PM.png

Re: Best practices for deploying a JMP model into a SQL database environment?

Also be aware that SAS offers EMiner and Model Manager for this specific task. Which is to deploy models at an enterprise level

Chris Kirchberg

JMP Technical Enablement Engineer

Worldwide Technical Enablement Team

SAS Institute, Inc.

Denver, CO

Tel: +1-919-531-9927

Mobile: +1-303-378-7419

E-mail: chris.kirchberg@jmp.com

Re: Best practices for deploying a JMP model into a SQL database environment?

Phil: The customer is a telemarketing company so they fit the customer segments you mention very well.

Re: Best practices for deploying a JMP model into a SQL database environment?

As SQL Expr (); will turn a formula into a SQL Expression. It doesn't work for everything but typically gets you close.

For example:

Save prediction formula to a column, open up the formula editor and copy the formula:

10653_Screen Shot 2015-12-15 at 4.49.26 PM.png

Paste it into a script editor wrapped with:

As SQL Expr(

Expr(

)

);

Run script and copy the resulting SQL code.

10654_Screen Shot 2015-12-15 at 4.50.12 PM.png

BTW this also works with As SAS Expr(); with similar results.

Re: Best practices for deploying a JMP model into a SQL database environment?

I don't have an answer but would be interested to know if others do. This question comes up quite often with customers in finance, marketing and insurance. I never have a very good answer.