ipacheck is Innovations for Poverty Action's Stata package for running high-frequency checks during data collection. This package includes the following programs:
ipacheckcorrections
- make corrections to data.ipacheckspecifyrecode
- recode other specify values.ipacheckversions
- export statistics on survey form versions & flags outdated survey submissions.ipacheckids
- export duplicates in survey ID.ipacheckdups
- export duplicates in non-ID variables.ipacheckmissing
- export statistics on missingness & distintness for each variable.ipacheckoutliers
- export outliers in numeric variables.ipacheckspecify
- export all values specified for variables with 'other speciy' category.ipacheckcomments
- export field comments generated with SurveyCTO's comments field type.ipachecktextaudit
- export statistics on duration per field using the SurveyCTO's text audit files.ipachecktimeuse
- export statistics on hours of engagement using the SurveyCTO's text audit files.ipachecksurveydb
- export general statistics about dataset.ipacheckenumdb
- export general statistics about enumerator performance.ipatracksurvey
- export dashboard for tracking survey progress.ipabcstats
- compare survey and back check data.
ipacodebook
- export codebook to excel. Includes an option to use notes as variable labelsipasctocollate
- collate and export a dataset from SurveyCTO generated text audit or comments files.ipalabels
- remove labels or values from variables.ipagettd
- convert datetime variables to date.ipagetcal
- create a date calendar dataset.ipaanycount
- create a variable that returns the number of variables in varlist for which values are equal to any specified integer/string value.
addlines
- add a lower boder line to a row in an excel file.addflags
- add a background color to a cell in an excel file.colwidths
- adjust column widths in excel file using length of values in current dataset.colformats
- apply number format to a column in an excel file.setfont
- set font size and type for a range of cells in an excel file.setheader
- set the first row in an excel file as a header row.settotal
- set the last row in an excel file as a total row.
ipacheck comes with a folder structure for your project including a master do-file, a globals do-file, prep do-file and Excel-based inputs sheets. Results of checks are exported as nicely formatted Excel spreadsheets for distribution among field teams.
* ipacheck may be installed directly from GitHub
net install ipacheck, all replace from("https://raw.githubusercontent.com/PovertyAction/high-frequency-checks/master")
ipacheck update
* after initial installation ipacheck can be updated at any time via
ipacheck update
* to start a new project with folder structure and input files
ipacheck new, surveys("SURVEY_NAME_1") folder("path/to/project")
* when starting a new project with multiple surveys, you can choose to use the subfolders option to create subfolders for each survey
ipacheck new, surveys("SURVEY_NAME_1" "SURVEY_NAME_2") folder("path/to/project") subfolders
* to obtain fresh copies of the master do-file and Excel inputs without creating the folder structure
ipacheck new, filesonly
* to go through IPA's exercise with instructions, exercise data, and folder structure with input files
ipacheck new, exercise
* to verify you have the latest versions of the commands
ipacheck version
If you encounter a clear bug, please file a minimal reproducible example on github. For questions and other discussion, please email us at researchsupport@poverty-action.org.
- Ishmail Azindoo Baako
- Rosemarie Sandino
- Christopher Boyer
- Isabel Onate
- Kelsey Larson
- Caton Brewster