worldbank / iefieldkit

Stata commands designed for Impact Evaluations field work. These are tools that are used during/after a survey in the field for data quality monitoring.
MIT License
39 stars 18 forks source link

ietestform: non-numeric name values check for database search #174

Open stevenglover opened 4 years ago

stevenglover commented 4 years ago

I might be wrong here :) but I think a correct practice for searching for options choices in an attached dataset would be to have the 'value' in the choices tab refer to a variable name in the attached dataset.

In this case, the flag for non-numeric choice names would catch this and call it an error.

Suggestion is to only flag this error when the associated row to the choice option does not have 'search(..)' in the appearance column.

E.g. from the ietestform read out:

There are non numeric values in the [value] column of the choice sheet
  
  | row | list_name | value | label
  | 71 | prov | provid | provname
  | 72 | dist | distid | distname
  | 73 | com | comid | comname