topic Re: How can I set the value of a specified column to the displayed value, ignoring the original significant digit? in Discussions

How can I set the value of a specified column to the displayed value, ignoring the original significant digit?

lala — Thu, 08 Jun 2023 16:43:01 GMT

For example, make the actual values of the "new" column in table 2 all integers.

dt=Open("$SAMPLE_DATA/Big Class.jmp");
d2=dt<<Summary(Group(:age),Mean(:height),Freq("None"),Weight("None"),Link to original data table(0));
Column(d2,3)<<Format("Fixed Dec",20,0);
d2<<New Column("new",formula(As Column(3)));d2<<run formulas;Column("new")<<deleteFormula;

Re: How can I set the value of a specified column to the displayed value, ignoring the original significant digit?

txnelson — Sun, 15 Jan 2023 05:23:44 GMT

All you have to do is to set the format for the column to something like

<< Format( "Fixed Dec", 6, 0 );

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
d2 = dt << Summary(
	Group( :age ),
	Mean( :height ),
	Freq( "None" ),
	Weight( "None" ),
	Link to original data table( 0 )
);
Column( d2, 3 ) << Format( "Fixed Dec", 20, 0 );
d2 << New Column( "new", formula( As Column( 3 ) ) );
d2 << run formulas;
Column( "new" ) << deleteFormula << Format( "Fixed Dec", 6, 0 );

To capture the original format, and use it I found this method to work

Eval( Parse( "Column(d2,4) <<" || Char( column(dt,4) << get format ) || ";" ) );

Re: How can I set the value of a specified column to the displayed value, ignoring the original significant digit?

lala — Sun, 15 Jan 2023 05:52:53 GMT

It seems that JMP does not have this feature and excel can implement this device.
The "new" column I added in the example simply checks that the precision of column 3 is an integer.

Thanks!