turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Interpreter for JMP formulas?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 4, 2014 8:52 AM
(1703 views)

Is there a way to make use of a JMP formula outside JMP that does not involve SAS or SAS Model Manager? If I do a linear regression in JMP with continuous variables and then want to make use of that model elsewhere, it's a simple step to put the linear equation into Excel or code it in to just about anything. However, for something more complicated like using nominal variables in regression or something incredibly complex like a boosted tree (in JMP Pro), making use of the prediction formula outside JMP by translating it into some other "language" is very tedious at best and approaching impossible at worst. I've seen "Get SAS Data Step for Formula Columns" and "Get MM SAS Data Step for Formula Columns", but this doesn't help if the model needs to be in Excel or any other system that performs calculations.

Unless I'm missing an important feature, JMP does not offer a way to "export" a formula to something common like VBA. I'm wondering if anyone knows about a third-party solution to interpret a JMP formula and translate input to output through the formula outside of JMP. Of course, if there is some way that doesn't involve a third-party solution, that would be even better.

I'm not hopeful that anything like this exists, but I'd be incredibly happy to find that it does. Maybe there is a business opportunity if no solution currently exists.

5 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 4, 2014 10:03 AM
(1146 views)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 5, 2014 9:17 AM
(1146 views)

Yes it is possible. I've developed an application that allows a model (e.g. boosted tree or neural net) to be exported and viewed on a web page. The model is converted from JSL to Javascript. It could be exported to a language such as VB or C# but because we have to do runtime evaluation it's technically easier to support Javascript since it doesn't require compilation. The application was developed for a client - maybe I should try and encourage them to showcase it at next years Discovery Summit!

David Burnham

-Dave

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 5, 2014 10:00 AM
(1146 views)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 9, 2014 1:59 PM
(1146 views)

Tee, this is probably not the appropriate forum to have that discussion - let's catch up on LinkedIn. Dave

-Dave

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 5, 2014 10:47 AM
(1146 views)