Missing values

[#1]

Hello,

I want to make analysis (Chi2 test) but I would make it without missing values.

I don't find the formule in order to doesn't take in account this missing values.

Moreover, I would make a Chi2 to compare the proportion with a EVA pain level ≥4 (cf. variable in yellow) according to the Intervention (salmon color) = 0 between the 2 randomization groups (variable in red).

You will also find my data base in file attach.

Thank you +++

Vocab : "Données manquantes" = missing values ; EVA < 4 (code = 1 for EVA variable (in yellow) ; EVA > 4 code = 1 for EVA variable (in yellow) ; "Bras prise en charge habituelle" --> cf. Bras randomisation (in red) ; 

[#2 · Accepted solution]

I may have misunderstood your question, but what I think you want is to

1.  ignore the missing values in the EVA column (I just selected those rows and hid and excluded them), and

2.  look at the Fit Y (yellow) by X (salmon) separately for the 2 randomization groups (red), which I did by putting the randomization groups in the By box.

Attached is the file, and I'm sorry if I did not understand you correctly.

[#3]

Hello,

I didn't understand which column is used to indicate missing data. 

In the script below you can substitute that column for Age, and then use the local data filter in the report to filter out the desired rows.

Categorical(
	Structured( :BRAS RANDOMISATON * :Intervention, :EVA ),
	Share Chart( 0 ),
	Legend( 0 ),
	Test Response Homogeneity( 1 ),
	Local Data Filter(
		Add Filter( columns( :Age ), Where( :Age >= 11.94 & :Age <= 17 ) )
	)
)

[#4 · Accepted solution]

Thank you very much Byron ! +++

It is very nice to according time to me, I know it's simple but I am not confortable with jmp.

One more time thank you.

[#5]

 Thank you for your reply, it is a solution !