378935_en-US

liliconcom

JSL for converting a formula to its results

Hello,

I have the following jsl code 

 

dt << New Column( "I (%)", (:Mean * 100) );

 

that takes a column (Mean), multiplies by 100 and create a new column called I(%) with the formula.

 

I do not want the formula but just the result of the calculation in the new column. How can I do this?

 

Many thanks.

Automation and ScriptingConsumer and Market ResearchSharing and Communicating ResultsRe: JSL for converting a formula to its resultsMany thanks.Re: JSL for converting a formula to its resultsThanks! Very clear.Re: JSL for converting a formula to its resultsThank you very much, very useful.Re: JSL for converting a formula to its results

This maybe gets a bit out of topic and I can create different post to discuss this further...

 

Even though the documentation is what it is for Set Each Value (JMP documentation isn't always exactly on point...) I feel like it is the easiest way the way to handle cases like this. You can easily use complicated "formulas" with Set Each Value without worrying about removing the formulas later. With Values() the calculations might get a bit more difficult to do, see my example (I'm definitely not proficient with JSL Matrices so there is most likely way easier way to do what I did in my example).

 

Example with Formulas, Set Each Value and Values:

 

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");

//With formulas
newCol = dt << New Column("Formula_simple", Numeric, Continuous, Formula(:height*:weight));
newCol << Delete Formula;
newCol = dt << New Column("Formula_ColMin", Numeric, Continuous, Formula(:height*ColMin(:weight, :sex)));
newCol << Delete Formula;

//With Set Each Value
newCol = dt << New Column("SetEach_simple", Numeric, Continuous, Set Each Value(:height*:weight));
newCol = dt << New Column("SetEach_ColMin", Numeric, Continuous, Set Each Value(:height * ColMin(:weight, :sex)));

//With Values
newCol = dt << New Column("Values_simple", Numeric, Continuous, Values((:height << get values) :*</img> (:weight<< get values)));
newCol = dt << New Column("Values_ColMin", Numeric, Continuous, Values(
 Summarize(exg = By(:sex), exm = Min(:weight)); //get min values by group
 m_val = J(N Rows(dt),1,1);//matrix for values
 height_vec = :height << get values;
 For(i = 1, i <= N Items(exg), i++, //loop to "fill" matrix for values
  tempRows = Loc(:sex << get as matrix, exg[i]);
  m_val[tempRows] = height_vec[tempRows] * exm[i];
 );
 m_val;
));

What does Set Each Value do behind the scenes because it seems to work just fine? Should the documentation maybe be updated to include this behavior or new function created to do this? It could break quite many scripts people have if Set Each Values behavior were to be changed.

 

 

 

 

Re: JSL for converting a formula to its results

That behavior is the intended purpose of the << Set Each Value message as it is documented.

Re: JSL for converting a formula to its results

Cooler! I'd assumed each value had to be set to the same value.

Re: JSL for converting a formula to its results

Hee is a simple example using Set Each Value

names default to here(1);

dt=open("$SAMPLE_DATA\big class.jmp");

dt << new column("times100", numeric, continuous, set each value(:height*100));

Re: JSL for converting a formula to its results

That message is not helpful in this case. It is used to set every row in the target column to the same constant value.

 

Re: JSL for converting a formula to its results

Cool!

Re: JSL for converting a formula to its results

You do not need a formula at all. I recommend not using column formulas when scripting unless you want the values to dynamically change after the script is done. So your case could be solved this way:

 

dt << New Column( "I (%)", Numeric, Continuous, Values( (:Mean << Get Values) * 100) );

Re: JSL for converting a formula to its results

Try using <Re: JSL for converting a formula to its results

The wait(3) is just so you can watch it; it is not required after <

You can also use the formula editor to clear the formula for the same effect.

Re: JSL for converting a formula to its results

NamesDefaultToHere(1);

// Sample table
dt = Open("$SAMPLE_DATA/Big Class.jmp");

// Add a formula column
dt << NewColumn("BMI", Numeric, Continuous, Formula(:weight/(:height^2)));

// Make sure the formula is run
dt << runFormulas;

// Wait a little, then remove the formula
Wait(3);
Column(dt, "BMI") << deleteFormula;