cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
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 XIII

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