subset a table with category in a column and name the sub tables with the cat. name

robust1972

subset a table with category in a column and name the sub tables with the cat. name;

I wrote a short script as below but it name both table as "F" and "F2", rather than "F" and "M". Anything I did wrongly?

Names default to here(1);

dt=open("$SAMPLE_DATA/big class.jmp");

dtsumm = dt << Summary(

       Group( :sex )

);

for(x=1,x<=nrow(dtsumm),x++,

  dt<<select where(dt:sex==dtsumm:sex)<< subset(Output Table Name(:sex));

);

David_Burnham

I think where you are using :sex for the output table name you just need to replace it with dtsumm:sex.  Its picking up the values from the source table not the summary table.