turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Saving the prediction formula to an existing colum...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 18, 2009 6:38 PM
(2019 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??

Anyway, thanks in advance :)

Dave

11 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 19, 2009 5:49 AM
(1730 views)

f = column("prednew") << Get Formula;

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

Message was edited by: xan@jmp

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 19, 2009 6:03 AM
(1730 views)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 19, 2009 6:17 AM
(1730 views)

Note I fixed an error in my previous post by adding Name Expr() to make sure the formula is not evaluated

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 20, 2009 4:23 AM
(1730 views)

Thanks.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 26, 2009 5:18 PM
(1730 views)

Do you know how I can get the script to put the formula into a file as plain text?

Very appreciated,

Dave

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 27, 2009 6:12 AM
(1730 views)

f = Column( "saved formula col" ) << get formula;

t = Char( Name Expr( f ));

Save Text File( "myformula.txt", t );

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 27, 2009 2:22 PM
(1730 views)

Silly question, maybe, but...

How do I save a negative of the formula? i.e. formula * -1 ?

How do I save a negative of the formula? i.e. formula * -1 ?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 28, 2009 2:03 PM
(1730 views)

one more question...how do I concatenate formulas into the single file?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 1, 2009 9:04 AM
(1730 views)

t = "";

f = Column( "Pred Formula neg MxBmin" ) << get formula;

a = Char( Name Expr( f ));

t = Concat(t, a);

t = concat(t, "\!N");

t = concat(t, "\!N");

f = Column( "Pred Formula MxBmin" ) << get formula;

a = Char( Name Expr( f ));

t = Concat(t, a);

t = concat(t, "\!N");

t = concat(t, "\!N");

f = Column( "Pred Formula MxBmax" ) << get formula;

a = Char( Name Expr( f ));

t = Concat(t, a);

t = concat(t, "\!N");

t = concat(t, "\!N");

f = Column( "Pred Formula MrB" ) << get formula;

a = Char( Name Expr( f ));

t = Concat(t, a);

t = concat(t, "\!N");

t = concat(t, "\!N");

f = Column( "Pred Formula neg FzR0min" ) << get formula;

a = Char( Name Expr( f ));

t = Concat(t, a);

Save Text File( "myformula.txt", t );