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
- :
- How to export make binning formula script in JSL

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

Highlighted

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

Jul 2, 2019 10:27 AM
(1098 views)

I am able to use make binning formula for my datasets. But I want to export the script that enables the binning to happen. Does anyone know how I can achieve that?

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

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

Hi @aaronjiang,

When you use Make Binning Formula, a new column is created with the formula used to make those bins. You'll see in the columns list on the left that the binning column has the plus sign next to it -- that means there is a formula for that column.If you click that plus sign, or right-click the column header and select Formula, you can see the formula that JMP has written for you. If you double click that formula, you can see the JSL:

You can use that jsl in another formula column in another table if you want, so long as that table has the same column name you used in your original table. If you wish to copy the jsl to create the column and apply that formula, you can use the Copy Script For Selected Column(s) to Clipboard Add In.

If you would like more details on JMP Formulas in general, I suggest you watch one of the Mastering JMP Webinars. I suggest Using Formulas to Get the Most from Your Data

I hope this helps!

1 REPLY 1

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

Hi @aaronjiang,

When you use Make Binning Formula, a new column is created with the formula used to make those bins. You'll see in the columns list on the left that the binning column has the plus sign next to it -- that means there is a formula for that column.If you click that plus sign, or right-click the column header and select Formula, you can see the formula that JMP has written for you. If you double click that formula, you can see the JSL:

You can use that jsl in another formula column in another table if you want, so long as that table has the same column name you used in your original table. If you wish to copy the jsl to create the column and apply that formula, you can use the Copy Script For Selected Column(s) to Clipboard Add In.

If you would like more details on JMP Formulas in general, I suggest you watch one of the Mastering JMP Webinars. I suggest Using Formulas to Get the Most from Your Data

I hope this helps!