106_en-US

liliconcom

Saving the prediction formula to an existing column?Hi,

I'm a new JMP user. I have several prediction formula saved to columns, and other columns linked to those. Now I want to update the formulas (many) in the original prediction columns with the new regression formula. Saving the prediction formula seems only possible to a new appended column. I suppose I could copy the formula from the new column and paste into the original column, but it's tedious. Perhaps the whole thing can be scripted, like excel's macro recorder??

Anyway, thanks in advance
DaveRe: Saving the prediction formula to an existing column?It can be scripted with JSL, but there's nothing like a macro recorder for tasks like that. You could do something like the following:

f = column("prednew") << Get Formula;
column("predold") << Set Formula( Name Expr( f ));

Message was edited by: xan@jmpRe: Saving the prediction formula to an existing column?Where would I put that code? Does it work on the newest added column, or a column of a particular name?