All,
Instead of doing a bunch of IF THEN ELSE statements in SAS, I can query whether a value is in a list:
If Color IN ("red", "blue", "green") Then State=1; else State=0;
In JMP formulas, what is the equivalent to the SAS IN() function?
Thanks, Al
Contains Item() may be the function you want
color="red"; contains item(color, {"red", "green", "blue"});
returns the value 1.
While not exactly the same, take a look at the Match function, or possibly, depending on the data and application, the Contains function.
Yes, that is the one I meant, not just contains!