how to scrip 'make tabulate into data table'

Isabel26

I think I am being nuts here. It should not be hard, but I just cannot make it work. I made a tabulate that I can click the option 'Make into data table', then save the data table. I want to script this so I can automate it. But no matter what I script, 'Make into data table' just won't work, either return me empty table, or error. Help is appreciated.

 

 

jthi

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;