cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar

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 :)
Dave
11 REPLIES 11

Re: Saving the prediction formula to an existing column?

xan-

Using Concat(a,b), what kind of quoting do I need to append the following to a string?

"MxBmin","[kNm]","=

...of course, the quotes are confusing the concat() function :(
XanGregg
Staff

Re: Saving the prediction formula to an existing column?

If you're trying to embed double quotes in a string, you can escape them with the two characters \! . For example:

s = "text with \!"quotation marks\!".";