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
- :
- JMP Data Manipulation

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

Jul 26, 2012 11:08 AM
(861 views)

I'm a newbie to JMP but have used SAS for years, with much emphasis on data preparation (e.g., PROC FORMAT). What's the best way to take a data table in JMP and group values for analysis? (e.g., age ranging from 0 to 99, want grouped into 1-5, 6-10, etc.)... or is the assumption that your data is already "prepped" once it hits JMP? I've looked at value labels and row states and nothing's jumping out at me.

5 REPLIES

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

Jul 26, 2012 12:09 PM
(603 views)

I'm sure you could use a formula for a column that takes the actual age and puts it into a "bin" 1-5, 6-10, etc. It would be tedious, but I am not aware of any non-tedious way to do this (even in SAS) if you really want the bins to be formatted as "1-5", "6-10", etc. If you just want bins without clear labels, things get much easier, create a formula that divides the age by 5 and then takes the floor of that division.

Of course, part of me is screaming ... don't turn continuous variables into bins, that's rarely a good thing to do for statistical analyses.

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

Jul 26, 2012 12:21 PM
(603 views)

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

Jul 28, 2012 2:48 PM
(603 views)

If you want to bin a continuous variable there are at least a couple of ways to do this.

One is to use the Distribution platform on the continuous column and choose Save Level Numbers or Save Level Midpoints.

These options will use the histogram bins to create new columns in your data table.

If you need adjust the histogram bins you can:

a) use the hand tool (press H on your keyboard) and drag in the histogram

b) use the Histogram OptionsSet Bin Width

If you want to specify your own cut points to bin your column you can use this add-in.

I hope that helps.

-Jeff

-Jeff

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

Jul 30, 2012 6:07 AM
(603 views)

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

Jul 30, 2012 8:34 AM
(603 views)