Saving the prediction formula to an existing column?
Feb 18, 2009 6:38 PM(4369 views)
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??
Re: Saving the prediction formula to an existing column?
Feb 19, 2009 6:17 AM(4080 views)
Put it in a script window and run it. Save it as a JSL file it you need it often. The given code has the column names built in. If you want the last column as the source, replace "prednew" with NCol().
Note I fixed an error in my previous post by adding Name Expr() to make sure the formula is not evaluated before it is added to the new column.