select isn't selecting the right items

Question

Hi,

I have number of iterations of the below....where each one uses a different X & Y column.  In 2 of these iterations the results are totally wrong and JMP selects a subset that is obviously wrong (lots of X < 40 and lots of Y that equal 1)

Any ideas?

//select X to get a list of items for this phase that need escalation
    dt <<Clear Select;
    dt <<Select Where( :X > 40 & :Y==0 );
    dt <lt;Subset(output table name("X subset"));

edit to make code example show up

Message was edited by: alex

pmroz · Answer

I take a different approach.  Instead of creating a subset each time I want to plot a different search, I simply exclude data that didn't meet the search criteria.  Next I  create a plot from the original dataset

dt << select where(:A > 40 & :B == 0) << invert row selection << exclude << clear select;

unknown · Answer

Hi man, I think tat you should use CART algorithm which is very fun !

anneg · Answer

Hello,

I had the same poblem (but I had the book :)   and now a further one, because I wanted generate a graph using the subset data table, but now I don't have a subset data table.

1. question: can I then create a subset data table with no rows in it - or with a dummy row?

2. question: Is there a easy possibility to check if the subset data exist and then create the graph (more complicated because i generate more than 1 graph with this Subset data table).