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 rearrange tables/results in JMP distributio...

- 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

Feb 7, 2017 3:30 AM
(932 views)

Dear All,

Suppose, I have two data sets. I am using standard example Sample library>> Big Class.jmp.

Data set 1: All the 40 students of a class.

Data set 2: Subset of just female students of the the class.

Need: I would like to compare distribution of [age,sex,height,weight] for Dataset 1 and 2.

For this I open both the reports, combine these reports using JMP>file> application. When I combine applications the distribution of age,sex,height,weight are in single window.

But I want in a form age(data set1) and age(data set 2) side by side and in same scale. then height(data set1) and height(data set 2) side by side and in same scale and so on for all other parameters in a single window.

My actual data sets are quiet large and it would be quiet useful when a parameter of data set1 and data set2 are side by side for easier comparison.

1 ACCEPTED SOLUTION

Accepted Solutions

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

Feb 7, 2017 9:41 AM
(1809 views)

Solution

here is a scripting example that gives the results you want

```
Names default to here(1);
dt=open("$SAMPLE_DATA/big class.jmp");
dt2=open("$SAMPLE_DATA/big class families.jmp");
column list = dt << get column names;
New Window( "Side by Side",
H List Box(
For( i = 1, i <= N Items( column list ), i++,
dt << Distribution( Column( column list[i] ) );
dt2 << Distribution( Column( column list[i] ) );
)
)
);
```

Jim

6 REPLIES

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

Feb 7, 2017 8:10 AM
(919 views)

Ultimately you will need all of the data set 1 and data set 2 observations in the same data table. If they start out as separate data tables, then use Tables > Concatenate to bring them together. Make sure that the common variables use the same column names first. Also, make sure that there is a column to indicate membership (i.e., data set 1 or data set 2). If they are already together, then you only need the column for membership. The membership column should use the nominal modeling type.

The Distribution platform freatures should support what you want to do. Select all of the respoinse columns and assign them to Y. Select the membership column and assign it to By role. Examine the red triangle menu: Stack will rearrange the order, Uniform Scaling will make the axes match. You can use the Ctrl-click feature with the red triangle to 'broadcast' the command.

Learn it once, use it forever!

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

Feb 7, 2017 9:10 AM
(910 views)

Hi Mark,

Thanks for your reply. I have already done it.

But I want the distribution table for a parameter for both data sets just side by side for comparison. {I have 60 input paramters}.

Please check a ppt, results I get by following steps you have mentioned and also what I actual need.

Thanks

San

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

Feb 7, 2017 9:41 AM
(1810 views)

here is a scripting example that gives the results you want

```
Names default to here(1);
dt=open("$SAMPLE_DATA/big class.jmp");
dt2=open("$SAMPLE_DATA/big class families.jmp");
column list = dt << get column names;
New Window( "Side by Side",
H List Box(
For( i = 1, i <= N Items( column list ), i++,
dt << Distribution( Column( column list[i] ) );
dt2 << Distribution( Column( column list[i] ) );
)
)
);
```

Jim

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

Feb 7, 2017 10:10 AM
(903 views)

Hi Txnelson,

Thanks alot.

Thats perfectly what I need. I was really struggling for this since 4days.

I will try to write in similar fashion to my data sets.

Regards

San

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

Feb 7, 2017 10:31 AM
(900 views)

Is there a way I can have same scale for the side by side tables so obtained?

Thanks for your help.

Thanks for your help.

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

Feb 7, 2017 11:14 AM
(897 views)

OK.....I just checked the date when you joined the community......and you have been online for over a year.........so you already know the answer to your question.......

This is JMP, and of course you can have the axes match. :-)

all that needs to be done is to capture the axis settings from the first graph of the pair, and then copy them to the second graph.

```
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );
dt2 = Open( "$SAMPLE_DATA/big class families.jmp" );
column list = dt << get column names;
New Window( "Side by Side",
H List Box(
For( i = 1, i <= N Items( column list ), i++,
dis1 = dt << Distribution( Column( column list[i] ) );
dis2 = dt2 << Distribution( Column( column list[i] ) );
Report( dis1 )[Axis Box( 1 )] << copy axis settings;
Report( dis2 )[Axis Box( 1 )] << paste Axis settings;
)
)
);
```

Jim