The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Fertility » Calculating fertility rates
Re: Calculating fertility rates [message #17996 is a reply to message #17995] Mon, 12 August 2019 10:34
 schoumaker Messages: 53Registered: May 2013 Location: Belgium Senior Member
Hello,

For the most recent DHS, you can use the following syntax to compute the TFR and the standard error of the TFR by district, and to save them to an excel file. In this example, I compute it for 5-year windows to reduce standard errors.

I cannot tell you if these district-level estimates are trustworthy; you should look at the confidence intervals, documentation on sampling, etc.

For the 1999 Indian DHS, you would need to use an all-women factor, and to my knowledge they are not available for at the district level in the data file. You could compute them yourself, but there may be a good reason for not making them available in the data file.

Best regards,

Bruno

****
use "IAIR74FL.DTA", clear

putexcel set "tfr2_district.xls", replace
putexcel A1=("District") B1=("TFR") C1=("S.E.")

levelsof sdistri, local(levels)

local i=1
foreach d of local levels {
tfr2 if sdistri==`d', len(5) norates
local i=`i'+1
putexcel A`i'="`d'" B`i'=_b[TFR] C`i'=_se[TFR]
}

Bruno Schoumaker
Centre for Demographic Research
Université catholique de Louvain

 Calculating fertility rates By: DHS user on Tue, 26 February 2013 09:55 Re: Calculating fertility rates By: Reduced-For(u)m on Tue, 26 March 2013 16:22 Re: Calculating fertility rates By: schoumaker on Thu, 30 May 2013 09:51 Re: Calculating fertility rates By: amaustin on Wed, 25 February 2015 12:16 Re: Calculating fertility rates By: schoumaker on Fri, 27 February 2015 03:19 Re: Calculating fertility rates By: amaustin on Fri, 27 February 2015 11:28 Re: Calculating fertility rates By: Trevor-DHS on Fri, 27 February 2015 13:52 Re: Calculating fertility rates By: annfitz on Tue, 26 May 2015 12:25 Re: Calculating fertility rates By: schoumaker on Tue, 26 May 2015 14:34 Re: Calculating fertility rates By: mianrashid on Mon, 19 September 2016 04:38 Re: Calculating fertility rates By: Liz-DHS on Mon, 19 September 2016 08:51 Re: Calculating fertility rates By: schoumaker on Mon, 19 September 2016 09:00 Re: Calculating fertility rates By: Kirwana Venantius Bbaale on Mon, 24 October 2016 04:09 Re: Calculating fertility rates By: schoumaker on Mon, 24 October 2016 04:12 Re: Calculating fertility rates By: Kirwana Venantius Bbaale on Mon, 24 October 2016 07:41 Re: Calculating fertility rates By: schoumaker on Mon, 24 October 2016 07:42 Re: Calculating fertility rates By: Kirwana Venantius Bbaale on Mon, 24 October 2016 09:26 Re: Calculating fertility rates By: schoumaker on Mon, 24 October 2016 09:34 Re: Calculating fertility rates By: schoumaker on Mon, 24 October 2016 10:00 Re: Calculating fertility rates By: Kirwana Venantius Bbaale on Mon, 24 October 2016 11:02 Re: Calculating fertility rates By: Kirwana Venantius Bbaale on Mon, 24 October 2016 11:04 Re: Calculating fertility rates By: Kirwana Venantius Bbaale on Tue, 25 October 2016 06:19 Re: Calculating fertility rates By: schoumaker on Tue, 25 October 2016 06:54 Re: Calculating fertility rates By: rajaram on Mon, 09 October 2017 02:31 Re: Calculating fertility rates By: schoumaker on Mon, 09 October 2017 02:42 Re: Calculating fertility rates By: rajaram on Tue, 10 October 2017 05:17 Re: Calculating fertility rates By: Jayanta on Tue, 21 August 2018 10:32 Re: Calculating fertility rates By: adasgupta on Mon, 12 August 2019 05:10 Re: Calculating fertility rates By: schoumaker on Mon, 12 August 2019 10:34
 Previous Topic: NFHS-4 Median Birth interval Next Topic: cannot reproduce TFR using R-package DHS.rates
Goto Forum:

Current Time: Wed Jul 28 04:08:06 Coordinated Universal Time 2021