cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
switzal87
Level III

How to Change a COL name of a SUMMARIZED table

Hello JMP community,

 

I would like to know how can I rename a column name after executing the "SUMMARY" function in JMP.

My raw data table is as shown:
1.JPG

 

 

 

 

and I would require to Summarized this (get the average) and I will have the following data table:2.JPG

 

 

 

 

 

Now for my final table, I would want to rename the following:

Mean(DIMENSIONA) to "DIMENSIONA" only ,

Mean(DIMENSIONB) to "DIMENSIONB" only,

Mean(DIMENSIONC) to "DIMENSIONC" only and so on...

Im using the following code to do it but no to avail.

3.JPG

 

.

 

I am getting the following log. I dont know the work around, seems like the "Mean" is a function word so that's why I get this kind of error. 

4.JPG

 

 

 

 

I hope someone can help find solution or do anything about it. Much appreciated everyone's help!

thanks in advance! :) 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: How to Change a COL name of a SUMMARIZED table

You will not have to rename the columns in the summary output table if you use the 

     statistics column name format( "column" )

option in the Summary Platform.  This is also a selection in the interactive dialog box on the lower left side, in an area titled "statistics column name format: 

Here is a simple script illustrating what I am saying

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\Fitness.jmp" );

dtSum = dt << Summary(
	Mean( :Age ),
	Mean( :Weight ),
	Mean( :Oxy ),
	Mean( :Runtime ),
	Mean( :RunPulse ),
	Mean( :RstPulse ),
	Mean( :MaxPulse ),
	Freq( "None" ),
	Weight( "None" ),
	statistics column name format( "column" ),
	Link to original data table( 0 )
);

Jim

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: How to Change a COL name of a SUMMARIZED table

You will not have to rename the columns in the summary output table if you use the 

     statistics column name format( "column" )

option in the Summary Platform.  This is also a selection in the interactive dialog box on the lower left side, in an area titled "statistics column name format: 

Here is a simple script illustrating what I am saying

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\Fitness.jmp" );

dtSum = dt << Summary(
	Mean( :Age ),
	Mean( :Weight ),
	Mean( :Oxy ),
	Mean( :Runtime ),
	Mean( :RunPulse ),
	Mean( :RstPulse ),
	Mean( :MaxPulse ),
	Freq( "None" ),
	Weight( "None" ),
	statistics column name format( "column" ),
	Link to original data table( 0 )
);

Jim
switzal87
Level III

Re: How to Change a COL name of a SUMMARIZED table

Thanks a lot! Works perfectly!