Create a tabulate, fron red triangle menu choose make into datatable, from new table check source table script (right click + edit). This should give you a good idea how to script it:
(Data Table("Big Class") << Tabulate(
Show Control Panel(0),
Add Table(
Column Table(Analysis Columns(:weight), Statistics(Mean)),
Row Table(Grouping Columns(:sex))
)
)) << Make Into Data Table
Full example:
Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
tab = dt << Tabulate(
Show Control Panel(0),
Add Table(
Column Table(Analysis Columns(:weight), Statistics(Mean)),
Row Table(Grouping Columns(:sex))
)
);
dt_tab = tab << Make Into Data Table;
show(dt_tab);
//to close tabulate use
//tab << Close Window;
-Jarmo