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:
and I would require to Summarized this (get the average) and I will have the following data table:
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.
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.
I hope someone can help find solution or do anything about it. Much appreciated everyone's help!
thanks in advance! :)
Go to Solution
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 )
View solution in original post