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

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.

 

1 Comment
hogi
Level XII

Workaround:
use a transform column as a dummy to calculate the values.
Then no real column is added to the data table.