Changing the format of a variable in a data table

Mickyboy — Wed, 27 Nov 2019 00:45:58 GMT

Hi,

i have the following syntax:

dt2<< Summary(
	Group( :Sample ),
	Mean( :dilution factor, :l10t ),
	Freq( "None" ),
	Weight( "None" ),
	Output Table( "log10t" ),
	Std Err( :l10t ),
	Link to original data table(0)
);

Loq = Data Table( "log10t" );


Loq << column(:Mean(l10t)) <<Format( "Fixed Dec", 12, 4 );

Loq << column(:Name ("Mean(l10t)")) << Format( "Fixed Dec", 12, 4 );  

Column(Loq,:Mean(l10t)) << Set Format ( "Fixed Dec", 12, 4 );

so l get a data table using the above syntax, however, the variable Mean(l10t) it produces in the table has 10 decimal places, the next three lines of code are trying to re format to a fixed decimal place of 4, none has worked, could anyone please advise why??

Also when i work with variables in JMP sometimes i can use just :variable name to use the variable, quite often this wont work and i have to use :Name("Variable Name"), why??

Thanks

Re: Changing the format of a variable in a data table

txnelson — Wed, 27 Nov 2019 01:24:35 GMT

Either of these syntax forms will work

loq:Name("Mean(l10t)") << Format( "Fixed Dec", 14, 4 );

column( loq, "Mean(l10t)" ) << Format( "Fixed Dec", 14, 4 );

Re: Changing the format of a variable in a data table

Mickyboy — Wed, 27 Nov 2019 01:34:28 GMT

thanks Jim, i had tried several bits of code, that worked a treat

topic Changing the format of a variable in a data table in Discussions

Changing the format of a variable in a data table

Re: Changing the format of a variable in a data table

Re: Changing the format of a variable in a data table