Choose Language Hide Translation Bar
Highlighted
natalie_
Level V

How to create a summary table?

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
Highlighted
txnelson
Super User

Re: How to create a summary table?

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

10873_pastedImage_0.png

Jim

View solution in original post

4 REPLIES 4
Highlighted
KarenC
Super User

Re: How to create a summary table?

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

Highlighted
txnelson
Super User

Re: How to create a summary table?

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

10873_pastedImage_0.png

Jim

View solution in original post

Highlighted
DaveLee
Level IV

Re: How to create a summary table?

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);

Highlighted
natalie_
Level V

Re: How to create a summary table?

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

Article Labels

    There are no labels assigned to this post.