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

iecorrect: how to deal with precision issues #187

Closed luizaandrade closed 2 years ago

luizaandrade commented 3 years ago

One issue that may arise from using Excel is that when a value is stored in a different format in Excel than in Stata, testing for equality before making a correction may result in corrections not being applied due to 2.999999 being different from 3, for example.

We should discuss this further, and the solution will depend on how Stata handles different formats. Documentation about this can be found in section 13.12 of the Stata manual, "Precision and problems therein"