Discussions
Solve problems, and share tips and tricks with other JMP users.
Created:
| Last Modified:
JMP formula : Missing value
Hi there~ ^^
Could you do me a favor?
Do you have any idea with this? I think this is a simple question, but I dont know yet.
I want to select "Missing continous value" in formula.
I wanna change missing continous values to "Unknow" with character value.
1 ACCEPTED SOLUTION
Accepted Solutions
Created:
| Last Modified:
Use the "IS MISSING()" function:
The JSL code looks like this:
If (:Thickness <= 0.15, "Under 0.15",
:Thickness > 0.15, "Over 0.15",
Is Missing( :Thickness ), "Unknown"
)
Created:
| Last Modified:
Use the "IS MISSING()" function:
The JSL code looks like this:
If (:Thickness <= 0.15, "Under 0.15",
:Thickness > 0.15, "Over 0.15",
Is Missing( :Thickness ), "Unknown"
)