BEGIN { FS = ";" } $3 == "" || $3 == "NA" { print $1, "missing"; next } { print $1, "present", $3 + 0 }