added missing value detection