stata programs

Stata Programs included in ipacheck Package

Overview

The ipacheck package includes Stata programs, files, folder structure and a template data flow for managing the quality of your data. The package includes the following programs:

Main 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 & distinctness for each variable.
• ipacheckoutliers - export outliers in numeric variables.
• ipacheckconstraints - export constraint violations in numeric variables.
• ipacheckspecify - export all values specified for variables with 'other specify' category.
• ipacheckcomments - export field comments generated with SurveyCTO's comments field type.
• ipachecktextaudit - export statistics on duration per field using SurveyCTO's text audit files.
• ipachecktimeuse - export statistics on hours of engagement using SurveyCTO's text audit files.
• ipachecksurveydb - export general statistics about the dataset.
• ipacheckenumdb - export general statistics about enumerator performance.
• ipatracksurvey - export dashboard for tracking survey progress.
• ipabcstats - compare survey and back check data.

Ancilliary programs

• ipacodebook - export codebook to excel. Includes an option to use notes as variable labels
• ipasctocollate - 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.

Mata library

• addlines - add a lower border 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 the length of values in the current dataset.
• colformats - apply a 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.

This page provides a more detailed explanation of each program in the ipacheck package as well as why, when and how to use each check. It is important to recognize that the ipacheck package is a collection of Stata programs that can be used within the DMS workflow or independent of it. Although we provide a template data flow with do-files and a folder structure, users can use these programs independently as well.