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
- :
- Discussions
- :
- Column Formula to display difference between two r...

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
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 4, 2011 10:05 AM
(5269 views)

My data set is-

Vg Ig Igs

0 1 1

1 5 4

2 7 2

3 3 -4

I would like to create column Igs which is difference between current row and previous row in the column Ig. Is it possible script something like this in jmp.

Thank you

Chivukula

Vg Ig Igs

0 1 1

1 5 4

2 7 2

3 3 -4

I would like to create column Igs which is difference between current row and previous row in the column Ig. Is it possible script something like this in jmp.

Thank you

Chivukula

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 6, 2011 7:52 PM
(8660 views)

Or this using the DIF function:

New Column( "lgs",

Numeric,

Continuous,

Formula( Dif( :lg, 1 ) )

)

If you are working interactively you can just create a new column and use the formula builder to enter the formula Dif(:lg, 1)

Michael

New Column( "lgs",

Numeric,

Continuous,

Formula( Dif( :lg, 1 ) )

)

If you are working interactively you can just create a new column and use the formula builder to enter the formula Dif(:lg, 1)

Michael

5 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 6, 2011 5:49 AM
(5080 views)

Hi:

Perhas this is one way:

Perhas this is one way:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 6, 2011 1:27 PM
(5080 views)

You can use the LAG function:

New Column( "lgs",

Numeric,

Continuous,

Formula( AsColumn("lg") - Lag( AsColumn("lg"), 1 ) ),

)

New Column( "lgs",

Numeric,

Continuous,

Formula( AsColumn("lg") - Lag( AsColumn("lg"), 1 ) ),

)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 6, 2011 7:52 PM
(8661 views)

New Column( "lgs",

Numeric,

Continuous,

Formula( Dif( :lg, 1 ) )

)

If you are working interactively you can just create a new column and use the formula builder to enter the formula Dif(:lg, 1)

Michael

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 12, 2011 7:45 AM
(5080 views)

Thank you so much for helping.

Regards,

Chivukula

Regards,

Chivukula

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Jun 6, 2011 12:06 PM
(5080 views)

Hello:

I am using bivarate plot and adding a fit line. I would like to save slope and intercept values in a text file. I am using following code:

biv=rbiv< Ex1=biv[NumberColBox(13)][2];

show(Ex1);

Show(Ex1) show the value of slope in the log file along with the log of entire session. Is it possible to send JSL command to save the values of just slopes and intercepts in to a new data table or seperate text file from the log.

Thank you

Regards,

Chivukula

I am using bivarate plot and adding a fit line. I would like to save slope and intercept values in a text file. I am using following code:

biv=rbiv<

show(Ex1);

Show(Ex1) show the value of slope in the log file along with the log of entire session. Is it possible to send JSL command to save the values of just slopes and intercepts in to a new data table or seperate text file from the log.

Thank you

Regards,

Chivukula