The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Fertility » Calculating WTFR
Calculating WTFR Thu, 02 October 2014 13:53
 DHS user Messages: 104Registered: February 2013 Senior Member
I am wondering how you classify a wanted birth (specifically what variables you use). I am trying to calculate state level WTFR for Nigeria 2008, and I cannot get my national number to match the one on stat compiler.
Re: Calculating WTFR [message #3001 is a reply to message #3000] Thu, 02 October 2014 13:58
 Bridgette-DHS Messages: 2554Registered: February 2013 Senior Member
Following is a response from Senior Data Processing Specialist, Noureddine Abderrahim:

The computation of the WTFR is a little bit more complicated than the TFR, since it excludes children whose birth order is above the ideal number declared by the respondent. The exposure used in the calculation of the WTFR, however, remains the same.

Attached is the logic used to compute the WTFR using the statistical package CSPro distributed by the Bureau of the Census.

• Attachment: wtfr.txt
Re: Calculating WTFR [message #4322 is a reply to message #3001] Fri, 08 May 2015 04:04
 schoumaker Messages: 58Registered: May 2013 Location: Belgium Senior Member
Hello,

Thank you for sharing the CSPro program. I tried to adapt it in Stata and compute WTFR in some countries. I got the same results as the published results in Niger 2012 for instance, but not in Niger 2006.

if V613 in 0:90 & chi < V613 then
colt606 = 1;
xtab( t606b, rweight )
endif;
colt606 = 2;

It seems children are declared as wanted if the number of surviving children at the time of conception is lower than the desired number of children (chi < V613) AND if v613 is between 0 and 90. The first condition is fine, but I am mot sure what this second condition means. This looks like children are considered unwanted in case V613>90, including if V613 is a non-numeric responses (v613=96).

Is my interpretation correct ? I also read in the Guide to DHS Statistics that "For ideal number of children, non-numeric and "don't know" responses are considered to be high numbers, so that all births are considered wanted. Births to women with missing information on ideal
number of births are considered as unwanted. " (GUIDE TO DHS STATISTICS, 2006, p.88); this seems to be different from the CSPro code.

Thank you in advance for looking at this.

Bruno

Bruno Schoumaker
Centre for Demographic Research
Université catholique de Louvain
Re: Calculating WTFR [message #4373 is a reply to message #4322] Fri, 15 May 2015 15:37
 Liz-DHS Messages: 1516Registered: February 2013 Senior Member
Dear Bruno,
Noureddine is temporarily unavailable, I am referring your query to another one of our experts. Thank you!
Re: Calculating WTFR [message #4384 is a reply to message #4322] Mon, 18 May 2015 11:30
 Trevor-DHS Messages: 774Registered: January 2013 Senior Member
There is a mistake in the code below that was recently corrected. Instead of using 0:90, it should use 0:98.

This was a problem for most surveys conducted under DHSVI, and errata have been released for most surveys. Please see:
http://www.dhsprogram.com/publications/publication-FR277-DHS -Final-Reports.cfm
for the errata for the Niger 2012 survey.

If you make the correction to your program to include up to 98, then you should match Niger 2006 and the corrected Niger 2012 table in the errata.
Re: Calculating WTFR [message #4390 is a reply to message #4384] Mon, 18 May 2015 15:10
 schoumaker Messages: 58Registered: May 2013 Location: Belgium Senior Member