topic Re: Is there Lead () function in JMP? in Discussions

Is there Lead () function in JMP?

bzanos — Fri, 09 Jun 2023 23:39:33 GMT

There is Lag() function in JMP which is intended to provide data values from preceding records in a data set.

Is there Lead() function in JMP? or any similar function that I can use?

What I am currently doing is to sort a data set in descending order and then apply lag functions to create lead values. Afterward the data are sorted a second time, back to original order, before any analysis is done.

Re: Is there Lead () function in JMP?

Jeff_Perkinson — Fri, 02 Oct 2020 13:50:15 GMT

You can use a negative number in the second argument to lag to indicate forward lag instead of backward. For example the formula:

Lag(:a, -1)

results in this table:

a	Lag(:a, -1)
57	61
61	91
91	8
8	70
70	9
9	99
99	37
37	16
16	89
89	.

Re: Is there Lead () function in JMP?

David_Burnham — Fri, 02 Oct 2020 13:52:29 GMT

Have you tried using the Lag function with a negative value for the lag parameter? Just a thought.

Re: Is there Lead () function in JMP?

bzanos — Fri, 02 Oct 2020 14:10:47 GMT

Thanks Jeff.

Re: Is there Lead () function in JMP?

txnelson — Fri, 02 Oct 2020 15:01:12 GMT

Being an Old Schooler, I have a tendency to use subscripting, so my formula for this would be

:a[Row() + 1]