topic row() results in missing value for 1st row in Discussions

row() results in missing value for 1st row

paulp — Thu, 08 Jun 2023 16:42:36 GMT

JMP® Pro 17.0.0 (622753)

Hello, I understand that using Lag in the 1st row results in a missing value. But I need to avoid a missing value, because my predictive algorithm is using Informative Missing elsewhere. So in this one instance, I'd like to avoid it.

I'm not much good with JSL...

Formula Result: want to force this missing value to change to a zero. My initial forays have been trying combinations of If statements using Is Empty, Is Missing. e.g.

If Lag (the whole formula) ==Is Empty

Then ==0

Else == Lag (the whole formula)

Any suggestions? thanks, Paul

Lag("the whole formula")

Re: row() results in missing value for 1st row

ih — Tue, 17 Jan 2023 21:44:16 GMT

Try putting your if statement outside of the lag function. So..

if( row() == 1, 
	hCounter = 1; // set the hCounter value so future evaluations work, but
	0;, //return 0 for the first row
	lag( ... )
)

Re: row() results in missing value for 1st row

paulp — Tue, 17 Jan 2023 22:45:03 GMT

Thank you, that did it