How to realize search 3 columns in the table, and if column "age, height, weight" any row value in same column value>100, then add new column name "Mark" fill in with "1", others NA.
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
Final result i want:
It is a simple script to handle what you want. Here is a formula to that can be specified for your column called Mark
If(:age > 100 | :Height >100 | :Weight > 100, 1, .)
There are no labels assigned to this post.