Subscribe Bookmark RSS Feed

How to create a summary table?

natalie_

Community Trekker

Joined:

Jan 6, 2016

Hi all,

I see that I can create a summary table that includes stats on the data. I have 8 columns, and I would like to calculate the min, max, mean and standard deviation of each column.  It is doing this, but I would like to format it to make it look more organized.  Each stat get its own column for each column, so 32 columns and 1 row.

I want to have it so that there is a column for each stat (mean, min, max, stdev) and a parameter column that has the name of each parameter in the rows.

Parameter     Mean     Max     Min     Stdev

P1

P2

P3

P4

P5

P6

P7

P8

Is it possible to create this using the table summary feature, or is there another way?

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

You should use the Analyze==>Tabulate platform.  It will allow you to create report outputs.

10873_pastedImage_0.png

Jim
4 REPLIES
KarenC

Super User

Joined:

Feb 10, 2013

In JMP 12 you could use the Columns Viewer (under the column menu).

Solution

You should use the Analyze==>Tabulate platform.  It will allow you to create report outputs.

10873_pastedImage_0.png

Jim
DaveLee

Community Trekker

Joined:

Jun 11, 2014

txnelson​'s approach is clearly a more streamlined and elegant approach.  I'm attaching the following script just to show how you can manually manipulate columns, etc.

dt=Open("C:\Program Files\SAS\JMP\12\Samples\Data\Semiconductor Capability.jmp");

summ = dt << Summary(

    Min( :NPN1 ),

    Min( :PNP1 ),

    Min( :PNP2 ),

    Min( :NPN2 ),

    Min( :PNP3 ),

    Min( :IVP1 ),

    Min( :PNP4 ),

    Min( :NPN3 ),

    Max( :NPN1 ),

    Max( :PNP1 ),

    Max( :PNP2 ),

    Max( :NPN2 ),

    Max( :PNP3 ),

    Max( :IVP1 ),

    Max( :PNP4 ),

    Max( :NPN3 ),

    Mean( :NPN1 ),

    Mean( :PNP1 ),

    Mean( :PNP2 ),

    Mean( :NPN2 ),

    Mean( :PNP3 ),

    Mean( :IVP1 ),

    Mean( :PNP4 ),

    Mean( :NPN3 ),

    Freq( "None" ),

    Weight( "None" )

);

stack = summ <<

Stack(

    columns(

        :Name( "Min(NPN1)" ),

        :Name( "Min(PNP1)" ),

        :Name( "Min(PNP2)" ),

        :Name( "Min(NPN2)" ),

        :Name( "Min(PNP3)" ),

        :Name( "Min(IVP1)" ),

        :Name( "Min(PNP4)" ),

        :Name( "Min(NPN3)" ),

        :Name( "Max(NPN1)" ),

        :Name( "Max(PNP1)" ),

        :Name( "Max(PNP2)" ),

        :Name( "Max(NPN2)" ),

        :Name( "Max(PNP3)" ),

        :Name( "Max(IVP1)" ),

        :Name( "Max(PNP4)" ),

        :Name( "Max(NPN3)" ),

        :Name( "Mean(NPN1)" ),

        :Name( "Mean(PNP1)" ),

        :Name( "Mean(PNP2)" ),

        :Name( "Mean(NPN2)" ),

        :Name( "Mean(PNP3)" ),

        :Name( "Mean(IVP1)" ),

        :Name( "Mean(PNP4)" ),

        :Name( "Mean(NPN3)" )

    ),

    Source Label Column( "Label" ),

    Stacked Data Column( "Data" ),

    Number of Series( 3 ),

    Output Table Name ("Stacked Data"),

    Contiguous

);

stack<<Delete Column(:N Rows);

stack<<New Column("Parameter", character, formula(Word(2, :Label, "()")));

stack << Move Selected Columns({“Parameter”}, To First);

Column("Parameter")<<Delete Formula;

stack<<Delete Column(:Label);

stack << Delete Column(:Label 2);

stack << Delete Column(:Label 3);

Column("Data") << Set Name("Min");

Column("Data 2") << Set Name("Max");

Column("Data 3") << Set Name("Mean");

Close(dt, NoSave);

Close(summ, NoSave);

natalie_

Community Trekker

Joined:

Jan 6, 2016

Thanks for the help guys!  I can use all these solutions in the future.