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
- :
- Discussions
- :
- How to split a data table in two

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

May 28, 2015 9:58 AM
(3467 views)

I'd like to randomly select 75% of my rows and save that to one data table and save the other random 25% of my rows to a second data table. Can this be accomplished in JMP?

1 ACCEPTED SOLUTION

Accepted Solutions

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

May 28, 2015 10:17 AM
(5563 views)
| Posted in reply to message from lauren_eggett 05/28/2015 12:58 PM

Here is one way to do it interactively:

1. Select 75% of rows by entering 0.75 in *Rows -> Row Selection -> Select Randomly...*

2. Make a subset of these 75% by selecting *Tables -> Subset* (check *Selected rows* and *All columns* in he Subset dialog)

3. Activate the original table (with the 75% still selected) and choose *Rows -> Delete Rows* to get rid of these rows and keep the remaining 25%.

2 REPLIES

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

May 28, 2015 10:17 AM
(5564 views)
| Posted in reply to message from lauren_eggett 05/28/2015 12:58 PM

Here is one way to do it interactively:

1. Select 75% of rows by entering 0.75 in *Rows -> Row Selection -> Select Randomly...*

2. Make a subset of these 75% by selecting *Tables -> Subset* (check *Selected rows* and *All columns* in he Subset dialog)

3. Activate the original table (with the 75% still selected) and choose *Rows -> Delete Rows* to get rid of these rows and keep the remaining 25%.

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

Re: How to split a data table in two

Thank you! That was very easy.