topic Re: Missing value codes not working in functions? in Discussions

Missing value codes not working in functions?

ron_horne — Fri, 11 Mar 2016 12:45:45 GMT

Hi All,

I was wondering what is the best practice for finding the listwise missing observations in a set.

I was using the “Is Missing” function in order to indicate missing observations. Yet the result was somewhat disappointing since it does not take into account missing value codes. Apparently, the missing value codes only works with platforms.

For example:

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

// set a missing value

:weight[1] = .;

// set missing value codes

:weight << set property ("Missing Value Codes", -1);

// set a missing category observation

:weight[2] = -1;

// new column indicating missing values for weight

dt << new column ("Missing", formula(If(Is Missing(:weight), 1, 0)));

The new column indicates row 1 as missing while not so for row 2.

Thanks,

Ron

Re: Missing value codes not working in functions?

ian_jmp — Fri, 11 Mar 2016 14:51:52 GMT

FWIW, in the JMP 13 build I have row 2 is indicated as missing by the formula column.

Regarding best practice in an earlier release, I guess that depends on the details. As you know you could write a JSL function to scan for the 'Missing Value Codes' property and respond accordingly. Perhaps this could also be put into a formula.

Re: Missing value codes not working in functions?

Jeff_Perkinson — Wed, 19 Oct 2016 02:08:09 GMT

What version of JMP are you using?

JMP 12 recognizes the missing value as defined by the Missing Value Codes property. The screen shot below is what I get after running your script.

By the way, if you ever want to get the actual value you can use Col Stored Value().

Re: Missing value codes not working in functions?

ron_horne — Fri, 11 Mar 2016 18:22:38 GMT

thanks Ian@JMP

i am using JMP 11 so it didn't work for me. good to know it is already fixed in more recent versions.

i may consider just deleting the missing value codes since i do not distinguish between them and actual missing values.

ron

Re: Missing value codes not working in functions?

ron_horne — Fri, 11 Mar 2016 18:23:42 GMT

Thanks Jeff.