2.1 DHS dataset types

The table below lists the different types of DHS data and their naming conventions in surveyPrev. You can find more details in this website

2.2 Function to process the indicator

Let’s take Current use of any modern method of contraception (all women) as an example. For users familiar with the standard indicators defined by the DHS Data Indicator API, the indicator ID is “FP_CUSA_W_MOD”. We will go through the steps to create the customized function below.

Step 1: Search indicator ID or key words in the Guide to DHS Statistics, and then identify which chapter it is in.

For our example, we can either search “FP_CUSA_W_MOD”, or “contraceptive”, and it is in chapter 7: family planning.

Figure 1: Screenshot of Step 1(a): Searching for indicator ID or key words.

Figure 2: Screenshot of Step 1(b): Identifying which chapter the indicator is from.

Step 2: We can download IndicatorList.xlsx from DHS GitHub site, and search keyword again in the the corresponding chapter to find out

1. which DHS data recode is used to create this indicator
2. which file contains the code to create this indicator in the DHS GitHub repository.
3. what the corresponding variable name is in the DHS GitHub repository.

For our example, since we are looking up for the indicator of all women currently using any modern method of contraception, we identify the cell “currently use any modern method”, and find out that the code to process this indicator is in the FP_USE.do file and we need IRdata (Individual Recode). We also identify the variable name used in the R codes on the Github repository is “fp_cruse_mod”. We will all three pieces of information in the next step to find the codes processing the indicator.

Figure 3: Screenshot of Step 2: Finding file name and recode name.

Step 3: In the Github repository, we find the folder for Chapter 7, the file FP_USE.R, and search “fp_cruse_mod” to find the following chunk of code script.

Figure 4: Screenshot of Step 3: Finding code.

We extract the following chunk of codes for this indicator, which takes the IR data, and perform a few steps of data cleaning.

# Currently use modern method
IRdata <- IRdata %>%
    mutate(fp_cruse_mod = ifelse(v313 == 3, 1, 0)) %>%
    set_value_labels(fp_cruse_mod = c(yes = 1, no = 0)) %>%
    set_variable_labels(fp_cruse_mod = "Currently used any modern method")

We can use the code chunk to define a new function to be used in the getDHSindicator function. The self-defined function should:

• Use Recode file as input and return the same data.frame.
• Change the name of your variable into "value" in the end.

The example below creates a fp_cruse_mod function for “Current use of any modern method of contraception (all women)”, which can be recognized by the getDHSindicator function later.

fp_cruse_mod <- function(RData) {
    IRdata <- RData %>%
        mutate(fp_cruse_mod = ifelse(v313 == 3, 1, 0)) %>%
        set_value_labels(fp_cruse_mod = c(yes = 1, no = 0)) %>%
        set_variable_labels(fp_cruse_mod = "Currently used any modern method")
    colnames(IRdata)[colnames(IRdata) == "fp_cruse_mod"] <- "value"
    return(IRdata)
}

Finally, after we create this function fp_cruse_mod, We can create the indicator by

1. Use getDHSdata function to downloading relevant DHS datasets using the identified DHS data type in Step 3. In this example we specify Recode = "Individual Recode" and indicator = NULL, The recode be one of the recode lists in table 1. to download the dataset. We can also set Recode = NULL, in which case all available DHS data types will be downloaded.
2. Use the function FUN = fp_cruse_mod in the call of getDHSindicator to process the indicator according to the customized function.

Altogether, the following codes creates the dataset of the processed indicator.

year <- 2018
country <- "Zambia"
Recode <- "Individual Recode"
dhsData <- getDHSdata(country = country, indicator = NULL, Recode = Recode, year = year)
data <- getDHSindicator(dhsData, indicator = NULL, FUN = fp_cruse_mod)
head(data)

##   cluster householdID    v024  weight strata value
## 1       1           1 eastern 1892890  rural     0
## 2       1           2 eastern 1892890  rural     0
## 3       1           3 eastern 1892890  rural     0
## 4       1           4 eastern 1892890  rural     1
## 5       1           7 eastern 1892890  rural     1
## 6       1           9 eastern 1892890  rural     1