BookmarkSubscribe
Choose Language Hide Translation Bar
switzal87
Community Trekker

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! :) 

0 Kudos
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
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
Highlighted
switzal87
Community Trekker

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

Thanks a lot! Works perfectly!
0 Kudos