cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
PhamBao
Level II

How to rename column of summary table?

Hi all,

I have one summary table and I would like to rename one or two columns of the summary table

 

My script is like below:

ST_NEW = dt << Summary(
	Group( :prodgroup3, :link_id, :complevel_1, :test_or_bond_head_id, :bondstage ),
	Mean( :align_ratio_2 ) << Name( "align " ),
	Std Dev( :align_ratio_2 ),
	Output Table Name( "ST_NEW" ), 

);

I would like to rename circled columns to new names

PhamBao_0-1649494389982.png

Could anyone help me to solve this?

Sincerely,


 

3 REPLIES 3
txnelson
Super User

Re: How to rename column of summary table?

there are 2 issue.

  1. By default, the summary daata table produced is Linked to the original table, which forces the table to be locked.  This defaule needs to be over ruled.
  2. The renaming of the column needs to be done after the new table is produced.
Names Default To Here( 1 );
// Open Data Table: big class.jmp
// → Data Table( "big class" )
dt = Open( "$SAMPLE_DATA/big class.jmp" );
ST_NEW = dt << Summary(
	Group( :sex ),
	Mean( :height ),
	Std Dev( :height ),
	Output Table Name( "ST_NEW" ),
	link to original data table( 0 )
);
ST_NEW:"Mean(height)"n << set name( "align" );
Jim
ih
Super User (Alumni) ih
Super User (Alumni)

Re: How to rename column of summary table?

If being linked to the original table is important (you want to select a row in the summary and have relevant rows in the original table be selected, for example) you could make a new column with the name you are looking for and then hide the original:

Names default to here(1);
dt = Open( "$SAMPLE_DATA/big class.jmp" );
ST_NEW = dt << Summary(
	Group( :sex ),
	Mean( :height ),
	Std Dev( :height ),
	Output Table Name( "ST_NEW" )
);
ST_NEW << New Column("align", Numeric, "Continuous", Format("Best", 12), Formula(:"Mean(height)"n));
ST_NEW:"Mean(height)"n << Hide( 1 );

Re: How to rename column of summary table?

you can also rename those stat columns with the drop down in below menu ...

Mandy_Chambers_0-1649770220689.png