dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Tabulate( // message to data table
	Add Table( // start a new table
		Column Table( Grouping Columns( :sex ) ), // group using the column sex
		Row Table( // add rows to the table
			Analysis Columns( :height, :weight ),
			// use the height and weight columns for the analysis
						Statistics( Std Dev, Mean )
					// show the standard deviation and mean
)));
You can apply a transformation to a column in the Tabulate table and set the format of the column at the same time. Use the Transform Column() function inside Analysis Column(). For example, the following script applies the Log transformation to height and sets the column format for the Mean and % of Total columns.
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Tabulate(
	Set Format(
		Mean(
			:height( 10, 1 ),
			Analysis Column(
				Transform Column(
					"Log[height]",
					Formula( Log( :height ) )
				),
				Format( 10, "Best" )
			)
		),
		Name( "% of Total" )(:height( 12, 2 ),
		Analysis Column(
			Transform Column(
				"Log[height]",
				Formula( Log( :height ) )
			),
			Format( 12, 2 )
		))
	),
	Add Table(
		Column Table(
			Analysis Columns(
				:height,
				Transform Column(
					"Log[height]",
					Formula( Log( :height ) )
				)
			),
			Statistics( Mean, Name( "% of Total" ) )
		),
		Row Table( Grouping Columns( :sex ) )
	)
);

Help created on 7/12/2018