dt << Summary( <private>, <invisible>, <Group( column )>, <Weight( column )>, <Freq( column )>, <N>, <Mean( column )>, <Std Dev( column )>, <Min( column )>, <Max( column )>...
The following example creates a summary table from the Fitness.jmp sample data table. The N Rows column, which specifies the number of rows for each level, is included in the Summary table by default. This script creates a column of the mean for Runtime by Sex.
dt = Open( "$SAMPLE_DATA/Fitness.jmp" );
dt << Summary(
Group( :Sex ),
Mean( :Runtime ),
);
dt = Open( "$SAMPLE_DATA/Fitness.jmp" );
dt << Summary(
Group( :Sex ),
Mean( :Runtime ),
Weight( "none" )
);
To unlink the Summary table, include Link to Original Data Table( 0 ) in the script.
dt = Open( "$SAMPLE_DATA/Fitness.jmp" );
dt << Summary(
Group( :Sex ),
Mean( :Runtime ),
Link to Original Data Table( 0 )
);