cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
0 Kudos

Add new << Calculate Values() function

Add new function which would return values in a list (or matrix if numeric calculation) based on column calculations. We can calculate values with Formula() and << Set Each Value, but we have to place the values in Data Table. It would be nice to be able to just calculate values based on the data table's columns WITHOUT adding new columns which you will have to later remove.

 

One idea for usage could be something like this (Big Class.jmp)

result = dt << Calculate Values(:Height / :Weight);

and this would then return me a matrix with :Height/:Weight calculated for each row.

 

Other example with characters could be

result = dt << Calculate Values(:sex ||"_"||Char(:age));

and this would return me a list of each row concatenated with :sex and :age.