topic Re: How to split a data table in two in Discussions

How to split a data table in two

lauren_eggett — Thu, 28 May 2015 16:58:41 GMT

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?

Re: How to split a data table in two

ms — Thu, 28 May 2015 17:17:39 GMT

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%.

Re: How to split a data table in two

lauren_eggett — Thu, 28 May 2015 17:34:12 GMT

Thank you! That was very easy.