What is the correct way to check if an image in a data table is missing?
... and why is there a difference between the column formula and the JSL question
is missing(:pet[5])
Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class Families.jmp" );
dt[[4],"pet"]=.;
New Column( "is missing",Formula( Is Missing( :pet ) ));
New Column( "is empty", Formula( Is Empty( :pet ) ));
New Column( "is number",Formula( Is Number( :pet ) ));
New Column( "is expr",Formula( Is expr( :pet ) ));
write("is missing:");
Show(is missing(:pet[4]));
Try(Show(is missing(:pet[5])), Print("is missing: error with existing image"));
write("\!n\!nis empty");
Show(is empty(:pet[4]));
Show(is empty(:pet[5]));
write("\!n\!nis number");
Show(is number(:pet[4]));
Show(is number(:pet[5]));
write("\!n\!nis expr");
Show(is expr(:pet[4]));
Show(is expr(:pet[5]));