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
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 28, 2015 9:58 AM
(2780 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?

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 28, 2015 10:17 AM
(4876 views)

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
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 28, 2015 10:17 AM
(4877 views)

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
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 28, 2015 10:34 AM
(2674 views)

Thank you! That was very easy.