Generate missing values with the function if

Question

Hello,

I have a database with many values (BMI, waist circumference, etc) from patients at two time points (T0, T1). Some values are missing.

I would like to create a formula that generates a missing value at T1, when T0 is missing (and the contrary).

Can someone help me with that ?

Thank you

txnelson · Answer

Here is one way to do what you want

Names Default To Here( 1 );
dt = Current Data Table();

For( i = 1, i <= N Rows( dt ), i++,
	If( Is Missing( dt:BMI[i] ),
		thePatient = dt:Patient[i];
		If(
			dt:Time[i] == "T0",
				dt:BMI[dt << get rows where(
					dt:Patient == thePatient & dt:Time == "T1"
				)] = .,
			dt:Time[i] == "T1",
				dt:BMI[dt << get rows where(
					dt:Patient == thePatient & dt:Time == "T0"
				)] = .,

);
	)
);

Shiel · Answer

Hereby an example of how my datatable is arranged !

Thank you for your help =)

Dataset.jmp

txnelson · Answer

Please attach a sample of your data table, or at least an image of the data table