The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Weighting data » SSU variables in the Mauritania DHS2019-2021 (The number of pregnant women who delivered their last child in the past five years preceding to the survey in Mauritania)
Re: SSU variables in the Mauritania DHS2019-2021 [message #28735 is a reply to message #28730] Fri, 01 March 2024 07:45 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member
Following is a response from Senior DHS Stata Specialist, Tom Pullum:

The variable to identify PSUs is v001 (duplicated as v021) and the variable for households, which are the SSUs, is v002. However, you don't need either of them. The following lines will give a table for the number of births that the sampled women had before August 2019, during August 2019, or after August 2019, for each region (v024), not just the two regions you mentioned.

Note that these are numbers of births to women in the sample. The number of births after August 2019 is affected by when the woman was interviewed. The fieldwork started in November 2019 and was stopped in March 2020 (there were 2 interviews in April 2020), and then resumed for two months in February-March 2021. If you are trying to get at the impact of COVID-19 on fertility, you will have to take the date of interview into account. Only the 5,016 women interviewed in 2021 could possibly show a COVID-19 effect.

* Number of births in the Mauritania 2019-21 survey before/after August 2019, by region

use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\MRBR71FL.DTA", clear

* Find the cmc for August 2019
summarize b3 if b1==8 & b2==2019
* August 2019 is b3=1436

* Construct a variable for the timing of births in the birth histories
gen birthdate=1
replace birthdate=2 if b3==1436
replace birthdate=3 if b3>1436

label define bd 1 "Before August 2019" 2 "In August 2019" 3 "After August 2019"
label values birthdate bd
tab v024 birthdate [iweight=v005/1000000]

Here is the table of weighted frequencies:

                      |            birthdate
               region | Before Au  In August  After Aug |     Total
----------------------+---------------------------------+----------
        hodh echargui | 5,398.926  40.237882 165.757235 |5,604.9211 
          hodh gharbi |4,306.5666  28.994562 137.206754 | 4,472.768 
               assaba | 3,542.996  19.488518  85.435286 |  3,647.92 
               gorgol | 3,866.476   21.88072  100.96081 | 3,989.317 
               brakna | 2,995.976  21.032225  97.846587 | 3,114.855 
               trarza | 1,992.851  16.385234  51.722557 | 2,060.959 
                adrar |676.115868   2.597507  16.480042 |695.193417 
   dakhlet nouadhibou |  1,097.09   4.328784  28.115727 | 1,129.534 
               tagant |867.836632   5.258122   23.18794 |896.282694 
           guidimagha |  3,860.71  23.182374 104.898378 | 3,988.791 
tiris zemour et inchi |589.395148    6.91581  15.450279 |611.761237 
     nouakchott ouest | 1,339.084   8.220457 146.107834 | 1,493.412 
      nouakchott nord |  4,009.97  17.350836 347.069054 |  4,374.39 
       nouakchott sud | 3,567.589  18.178068 302.901025 | 3,888.668 
----------------------+---------------------------------+----------
                Total | 38,111.58 234.051099   1,623.14 | 39,968.77

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Residing in same household in KR file
Next Topic: IPV -Domestic Violence
Goto Forum:
  


Current Time: Thu Nov 28 17:21:12 Coordinated Universal Time 2024