how to multiple column format at once in JMP Script I have them in a column group and all should be Fixed Dec, 15, 0 -thanks

Question

how to multiple column format at once in JMP Script I have them in a column group and all should be Fixed Dec, 15, 0 -than

txnelson · Accepted Answer

Select the columns you want to change the format to, then go to the pull down menu

Cols=>Standardize Attributes

and you will be able to set the format once and it will apply it to all of the selected columns.

Georg · Accepted Answer

In addition to interactive way of Jim, to do it as a Script see the following example:

Names Default To Here( 1 );
// define a column group and set format of that columns in the group

dt = Open( "$SAMPLE_DATA\Big Class.jmp" );
dt << group columns( "decimals", {:height, :weight} );

For Each( {value}, dt << get column group( "decimals" ),
	Print( value );
	value << Format( "Fixed Dec", 15, 3 );
);