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 can the results of summarize be made into a tr...

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

Sep 4, 2014 10:02 AM
(2925 views)

How can the results of a summarize be made into a true table like summary generates? http://www.jmp.com/support/help/Advanced_Data_Table_Scripting.shtml does not cover this issue directly.

I am trying to group a large data set by year and month, then calculate various percentiles for numeric data.

The goal is a new table of percentiles for each unique year/month subset.

I can use Quantile (<variable>,0.99) to get the 99th percentile in **summarize**, but not a table output;

I can get a table output from** summary**, but not the 99th percentile.

The summarize code is:

dt=current data table**()**;

summarize**(**

** **a = by**(**areaname, roomnbr, isoname, Site, year, quarter**)**,

nobs = count**(**CFU**)**,

nhole = count,

p99 = quantile**(**CFU,**0.99)**,

p95 = quantile**(**CFU,**0.95)**,

pmed = quantile**(**CFU,**0.50)**,

pave = mean**(**CFU**)**,

**)**;

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

Sep 4, 2014 11:42 AM
(5360 views)

Solution

It is possible, at least in JMP 11 and I think in several earlier versions, to get percentiles with *Summary*. There is a text box "*For quantile statistics, enter value (%)*".

JSL syntax:

dt << Summary**(** Group**(** :areaname, ... **)**, Quantiles**(** **99**, :CFU **)** **)** **);**

It is also possible to insert the results of *Summarize()* into a table, but it requires scripting that may become quite complex if a general solution ( e.g. varying nr of grouping cols and statistics) is desired.

1 REPLY

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

Sep 4, 2014 11:42 AM
(5361 views)

It is possible, at least in JMP 11 and I think in several earlier versions, to get percentiles with *Summary*. There is a text box "*For quantile statistics, enter value (%)*".

JSL syntax:

dt << Summary**(** Group**(** :areaname, ... **)**, Quantiles**(** **99**, :CFU **)** **)** **);**

It is also possible to insert the results of *Summarize()* into a table, but it requires scripting that may become quite complex if a general solution ( e.g. varying nr of grouping cols and statistics) is desired.