topic Re: JMP formula : Missing value in Discussions https://community.jmp.com/t5/Discussions/JMP-formula-Missing-value/m-p/7090#M7084 <HTML><HEAD></HEAD><BODY><P>Yeah!!!! Thank you so much PMroz. <SPAN __jive_emoticon_name="happy" __jive_macro_name="emoticon" class="jive_macro jive_macro_emoticon jive_emote" src="https://community.jmp.com/5.0.2/images/emoticons/happy.gif"></SPAN></P><P></P><P>have a nice day!!&nbsp;&nbsp; ^__^)/</P><P><BR /> </P></BODY></HTML> Wed, 10 Jul 2013 22:49:49 GMT Steve_Kim 2013-07-10T22:49:49Z JMP formula : Missing value https://community.jmp.com/t5/Discussions/JMP-formula-Missing-value/m-p/7088#M7082 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #575757; text-decoration: underline;"><STRONG>JMP formula : Missing value</STRONG></SPAN></P><P></P><P>Hi there~ ^^</P><P>Could you do me a favor? <SPAN __jive_emoticon_name="happy" __jive_macro_name="emoticon" class="jive_macro jive_macro_emoticon jive_emote" src="https://kvoqx44227.lithium.com/5.0.2/images/emoticons/happy.gif"></SPAN></P><P></P><P>Do you have any idea with this? I think this is a simple question, but I dont know yet.<SPAN __jive_emoticon_name="sad" __jive_macro_name="emoticon" class="jive_macro jive_macro_emoticon jive_emote" height="1" src="https://kvoqx44227.lithium.com/5.0.2/images/emoticons/sad.gif" width="1"></SPAN></P><P></P><P><SPAN style="color: #ff0000; font-size: 14pt;"><STRONG>I want to select "Missing continous value" in formula.</STRONG></SPAN></P><P>I wanna change missing continous values to "Unknow" with character value.</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="3865_Missing value.jpg" style="width: 902px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/182i12B1BA783F9A8F71/image-size/medium?v=v2&amp;px=400" role="button" title="3865_Missing value.jpg" alt="3865_Missing value.jpg" /></span></P></BODY></HTML> Tue, 18 Oct 2016 20:16:00 GMT https://community.jmp.com/t5/Discussions/JMP-formula-Missing-value/m-p/7088#M7082 Steve_Kim 2016-10-18T20:16:00Z Re: JMP formula : Missing value https://community.jmp.com/t5/Discussions/JMP-formula-Missing-value/m-p/7089#M7083 <HTML><HEAD></HEAD><BODY><P>Use the "IS MISSING()" function:</P><P></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="3867_Is Missing.png" style="width: 446px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/183i47FAC19B108F761C/image-size/medium?v=v2&amp;px=400" role="button" title="3867_Is Missing.png" alt="3867_Is Missing.png" /></span></P><P>The JSL code looks like this:</P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: #0000dd;">If</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;"> <STRONG>(</STRONG></SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: navy;">:</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">Thickness </SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: navy;">&lt;=</SPAN> <STRONG style="color: teal; font-size: 10.0pt; font-family: 'Courier New';">0.15</STRONG><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: navy;">,</SPAN> <SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: purple;">"Under 0.15"</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: navy;">,</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: navy;">&nbsp;&nbsp;&nbsp; :</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">Thickness </SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: navy;">&gt;</SPAN> <STRONG style="color: teal; font-size: 10.0pt; font-family: 'Courier New';">0.15</STRONG><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: navy;">,</SPAN> <SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: purple;">"Over 0.15"</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: navy;">,</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: #0000dd;">&nbsp;&nbsp;&nbsp; Is Missing</SPAN><STRONG style="color: black; font-size: 10.0pt; font-family: 'Courier New';">(</STRONG> <SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: navy;">:</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black;">Thickness <STRONG>)</STRONG></SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: navy;">,</SPAN> <SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: purple;">"Unknown"</SPAN></P><P><STRONG style="color: black; font-size: 10.0pt; font-family: 'Courier New';">)</STRONG></P></BODY></HTML> Tue, 18 Oct 2016 20:16:09 GMT https://community.jmp.com/t5/Discussions/JMP-formula-Missing-value/m-p/7089#M7083 pmroz 2016-10-18T20:16:09Z Re: JMP formula : Missing value https://community.jmp.com/t5/Discussions/JMP-formula-Missing-value/m-p/7090#M7084 <HTML><HEAD></HEAD><BODY><P>Yeah!!!! Thank you so much PMroz. <SPAN __jive_emoticon_name="happy" __jive_macro_name="emoticon" class="jive_macro jive_macro_emoticon jive_emote" src="https://community.jmp.com/5.0.2/images/emoticons/happy.gif"></SPAN></P><P></P><P>have a nice day!!&nbsp;&nbsp; ^__^)/</P><P><BR /> </P></BODY></HTML> Wed, 10 Jul 2013 22:49:49 GMT https://community.jmp.com/t5/Discussions/JMP-formula-Missing-value/m-p/7090#M7084 Steve_Kim 2013-07-10T22:49:49Z