How to make a formula (Delta / %Delta) in JMP

[#1]

Hi everyone, need some help..

From JMP sample data (Raleigh Temps) shown below, I had added the last 2 columns and made a calculation in excel based on the formula for "Delta in Temp" by month  as "=C2-$C$2, =C3-$C$2, =C4-$C$2 and so on.."  and  for "% Delta in Temp"  as "=G2/C2" (% formatted).

Now, I would like to do the same in JMP.  Could someone show me how to make the formula or script in JMP?  Thanks in advance  

Month	Year	Temperature	Month/Year	Predicted Temperature	Month Number	Delta in Temp	% Delta in Temp
1	1980	48.92	Jan-80	88.1859485	1	0	0%
2	1980	48.02	Feb-80	72.8224002	2	-0.9	-2%
3	1980	56.84	Mar-80	54.8639501	3	7.92	14%
4	1980	75.74	Apr-80	50.8215145	4	26.82	35%
5	1980	81.86	May-80	64.41169	5	32.94	40%
6	1980	86.54	Jun-80	83.139732	6	37.62	43%
7	1980	89.24	Jul-80	89.7871649	7	40.32	45%
8	1980	90.86	Aug-80	78.2423697	8	41.94	46%
9	1980	84.2	Sep-80	59.1195778	9	35.28	42%
10	1980	69.62	Oct-80	50.0001959	10	20.7	30%
11	1980	60.98	Nov-80	59.2685416	11	12.06	20%
12	1980	52.16	Dec-80	78.4033407	12	3.24	6%
1	1981	45.86	Jan-81	89.8121471	13	0	0%
2	1981	56.84	Feb-81	83.0057568	14	10.98	19%
3	1981	59.18	Mar-81	64.2419337	15	13.32	23%
4	1981	74.48	Apr-81	50.7720502	16	28.62	38%
5	1981	75.74	May-81	54.9802551	17	29.88	39%
6	1981	88.7	Jun-81	72.9975442	18	42.84	48%
7	1981	89.42	Jul-81	88.258905	19	43.56	49%
8	1981	83.84	Aug-81	86.7331128	20	37.98	45%
9	1981	79.34	Sep-81	69.8229738	21	33.48	42%
10	1981	69.44	Oct-81	53.0755919	22	23.58	34%
11	1981	62.24	Nov-81	51.8884328	23	16.38	26%
12	1981	48.56	Dec-81	67.352965	24	2.7	6%
1	1982	44.06	Jan-82	85.251169	25	0	0%
2	1982	55.04	Feb-82	89.1275186	26	10.98	20%
3	1982	62.96	Mar-82	75.4181158	27	18.9	30%
4	1982	69.62	Apr-82	56.7273223	28	25.56	37%
5	1982	83.84	May-82	50.2393675	29	39.78	47%
6	1982	84.02	Jun-82	61.9192471	30	39.96	48%
7	1982	88.34	Jul-82	81.0285336	31	44.28	50%
8	1982	86.36	Aug-82	89.9982372	32	42.3	49%
9	1982	80.96	Sep-82	80.5816537	33	36.9	46%
10	1982	71.06	Oct-82	61.4363466	34	27	38%
11	1982	63.5	Nov-82	50.1644229	35	19.44	31%
12	1982	57.02	Dec-82	57.1292373	36	12.96	23%

[#2]

I am also a beginner and need to know how to do it. As far as I know it is something related to functions"row" or "evaluate" but that's all I guess.

Probably a developer or a guru from SAS will lift you up.

Please also let me know when you've got it.

many thanks

[#3]

You use a subscript on a column reference to index into a specific row. In your case, row 1.

So the formula for Delta in Temp looks like this:

-Jeff

[#4]

And the percentage change may not make sense, especially as the temperature gets close to zero.  Zero Fahrenheit does not happen often in Raleigh.  But  same idea, without needing a subscript. 

[#5]

I just realized that you were resetting your Delta at the beginning of every year. In this case you'll need to index your subscript based on the month in the current row. Like this:

-Jeff

[#6]

It's not really different from Jeff's solution, but I like this:

[#7]

Thanks for all your helps! My question has been answered and did tried it on JMP. Thanks again.

Here's a new set of  data table below where basically do the same thing, ie, get the Delta in Data by Event Date. However, I have 3 serial numbers and 2 variables under LOC.

First, would like to convert the Event Date into Hours. Then take the Delta in Data by Hours by Serial no and Loc.

Really appreciated your quick reply.

EVENT_DATE	SERIAL NO.	LOC	DATA
05/04/2015 9:50 PM	1	0	422
05/04/2015 9:50 PM	1	1	389
05/05/2015 11:54 AM	1	0	423
05/05/2015 11:54 AM	1	1	387
05/06/2015 2:01 AM	1	0	423
05/06/2015 2:01 AM	1	1	385
05/06/2015 4:11 PM	1	0	422
05/06/2015 4:11 PM	1	1	386
05/07/2015 6:08 AM	1	0	424
05/07/2015 6:08 AM	1	1	387
05/07/2015 7:47 PM	1	0	428
05/07/2015 7:47 PM	1	1	389
05/08/2015 9:22 AM	1	0	425
05/08/2015 9:22 AM	1	1	389
05/04/2015 9:28 PM	2	0	564
05/04/2015 9:28 PM	2	1	454
05/05/2015 10:33 AM	2	0	564
05/05/2015 10:33 AM	2	1	456
05/05/2015 11:29 PM	2	0	565
05/05/2015 11:29 PM	2	1	455
05/06/2015 12:49 PM	2	0	567
05/06/2015 12:49 PM	2	1	454
05/07/2015 2:15 AM	2	0	567
05/07/2015 2:15 AM	2	1	454
05/07/2015 3:44 PM	2	0	567
05/07/2015 3:44 PM	2	1	454
05/08/2015 5:11 AM	2	0	566
05/08/2015 5:11 AM	2	1	454
05/08/2015 6:36 PM	2	0	567
05/08/2015 6:36 PM	2	1	452
05/04/2015 9:42 PM	3	0	422
05/04/2015 9:42 PM	3	1	506
05/05/2015 11:37 AM	3	0	421
05/05/2015 11:37 AM	3	1	505
05/06/2015 1:34 AM	3	0	422
05/06/2015 1:34 AM	3	1	502
05/06/2015 3:32 PM	3	0	421
05/06/2015 3:32 PM	3	1	502
05/07/2015 5:31 AM	3	0	423
05/07/2015 5:31 AM	3	1	508
05/07/2015 7:28 PM	3	0	421
05/07/2015 7:28 PM	3	1	502
05/08/2015 9:25 AM	3	0	421
05/08/2015 9:25 AM	3	1	503

[#8]

Date and Time Functions might help you get the hours you need from the date.