Saving the prediction formula to an existing column?
Feb 18, 2009 6:38 PM(4891 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??
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.