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
- :
- Re: How to express the Summary Statistics amount in the "table" with variables?

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

How to express the Summary Statistics amount in the "table" with variables?

Oct 10, 2018 3:35 AM
(205 views)

I need to pick your brain again:

Take this picture alone.The red box is where the number of columns is variable.

For the convenience of description, column 4 is used as the Group.

Column variables starting and ending in column 5 are the values requiring Summary.

How are the column names in the red boxes represented in the form of variables?

Thanks you!

dt = Open( "$SAMPLE_DATA/Boston Housing.jmp" );

2 REPLIES

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

Re: How to express the Summary Statistics amount in the "table" with variables?

The following code was provided by Jim when I consulted with the decision tree example.

But I don't know how to apply this to Summary.

Thank you!

colNamesList = dt << get column names;

xFactorList = As List( colNamesList[5 :: N Items( colNamesList )] );

Partition(……,X( Eval( xFactorList ) ),……

But I don't know how to apply this to Summary.

Thank you!

colNamesList = dt << get column names;

xFactorList = As List( colNamesList[5 :: N Items( colNamesList )] );

Partition(……,X( Eval( xFactorList ) ),……

Highlighted
##

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

Re: How to express the Summary Statistics amount in the "table" with variables?

I can only do variable form in this way at the moment.Thank you!