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 create a category nominal variable with mor...

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

Sep 9, 2015 8:42 AM
(2093 views)

2 ACCEPTED SOLUTIONS

Accepted Solutions

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

Sep 9, 2015 10:42 AM
(1933 views)

Solution

Hi Al,

Let's say you have a continuous column named A with values between zero and one. Create a column named B, character data type and nominal modeling type. Build a formula for B as follows:

You can add an arbitrary number of clauses to the If function using the caret "^" button in the formula builder.

Best,

Jordan

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

Sep 9, 2015 4:08 PM
(1932 views)

Solution

Jordan is right and that is probably what i would use most of the time. Yet, the fancy way to go about it would be to install this add in:

6 REPLIES

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

Sep 9, 2015 10:42 AM
(1934 views)

Hi Al,

Let's say you have a continuous column named A with values between zero and one. Create a column named B, character data type and nominal modeling type. Build a formula for B as follows:

You can add an arbitrary number of clauses to the If function using the caret "^" button in the formula builder.

Best,

Jordan

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

Sep 10, 2015 7:25 AM
(1870 views)

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

Sep 9, 2015 2:56 PM
(1870 views)

In JMP 12 there is an option *Make Binning Formula*. It's found in *Cols/Utilities *that may do what you need*. *I think it is limited to equal-width bins.

(On my machine it doesn't work at all, which seems to be related to me using comma as decimal delimiter which breaks the graphics script. If changing to an OS with english localization, the *Make Binning Formula* works beautifully).

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

Sep 10, 2015 7:25 AM
(1870 views)

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

Sep 9, 2015 4:08 PM
(1933 views)

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

Sep 14, 2015 5:55 AM
(1870 views)

If you have a lot of categories, another approach would be to use the Loc Sorted() function, with or without a lookup table. The following link takes you to a tutorial:

http://blogs.sas.com/content/jmp/2014/04/02/lookup-tables-in-jmp/

Cheers,

Brady