434954_en-US

liliconcom

how to scrip 'make tabulate into data table'

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.

 

 

Re: how to scrip 'make tabulate into data table'

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;

Re: how to scrip 'make tabulate into data table'

It worked! Thanks. I guess if I want to add name to the new data table, I just need to add ' output table name( "NEW NAME")' some where?