A summary table includes summary statistics for a data table, such as the mean, median, standard deviation, minimum value, and maximum value. You can use JSL to create a summary table.
By default, the summary table is linked to its source table. When you select rows in the summary table, the corresponding rows are highlighted in its source table.
dt << Summary( <private>, <invisible>, <Group( column )>, <Weight( column )>, <Freq( column )>, <N>, <Mean( column )>, <Std Dev( column )>, <Min( column )>, <Max( column )>...
Include columns for any statistic listed in the Summary launch window.
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 ),
);
You can override the preselected Freq or Weight columns in the data table by specifying the Freq or Weight columns in the script. To omit the preselected Freq or Weight, use the keyword "none".
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 )
);