| Afghanistan DHS [message #24491] |
Mon, 23 May 2022 19:19  |
Samishreyaan
Messages: 6
Registered: May 2022
|
Member |
|
|
I am working on teenage pregnancy project for Afghanistan, Bangladesh and many more. I need a sample for "all woman aged 15-19" instead of
"ever married woman aged 15-19". DHS for Afghanistan, Bangladesh and Pakistan collected the sample from ever married woman but the DHS report for teenage motherhood was presented for 'all woman'. Can you please assist me how do I increase it to all woman factor?
regards,
Sami
|
|
|
|
|
|
|
|
|
|
| Re: Afghanistan DHS [message #24530 is a reply to message #24527] |
Thu, 26 May 2022 19:38  |
Samishreyaan
Messages: 6
Registered: May 2022
|
Member |
|
|
Hi Janet,
I am currently working on pooled analysis from Afghanistan, Pakistan, Bangladesh, Nepal, Maldives and India DHS to find risk factors of teenage pregnancy. What I can see the sample of women is 'all woman 15-49 yrs' for Nepal, India and Bangladesh; whereas the sample of woman
for Afghanistan, Pakistan and Bangladesh is "ever married woman 15-49 yrs". This is where I applied all woman factor to increase the sample of woman for those three countries. By doing so, I did get an exactly sample number of woman sample as reported in DHS report but, failed to get the correct percentage of woman who have begun childbearing. For example, lets take Afghanistan DHS. My analysis showed Percentage of childbearing is 59.5% whereas the report states 12.1%.
my work on stata and the DHS report snapshots are attached below.
I wish to get quicker response, as I am running out of my time.
kind regards,
SAMI  
-
Attachment: snip 1.PNG
(Size: 10.38KB, Downloaded 528 times)
-
Attachment: snip 2.PNG
(Size: 4.28KB, Downloaded 393 times)
-
Attachment: snip 3.PNG
(Size: 31.28KB, Downloaded 533 times)
|
|
|
|
| Re: Afghanistan DHS [message #24531 is a reply to message #24530] |
Fri, 27 May 2022 03:17 |
schoumaker
Messages: 66
Registered: May 2013
Location: Belgium
|
Senior Member |
|
|
Hello,
This is due to the fact that you are weighting both the numerator and the denominator with awfactt.
You can try the syntax below.
Best,
Bruno
****
use AFIR71FL.DTA, clear
keep if v012>=15 & v012<=19
gene teenmom=0
replace teenmom=1 if v213==1|bidx_01==1
replace awfactt=awfactt/100
gene teenmom_prop=teenm/awfactt // divides each observation by the all-women factor
tabstat teenmom_prop [aw=v005*awfactt]
tabstat teenmom_prop [aw=v005*awfactt], by(v012) // by age
*** you will need to adapt the all women factor for comparisons by urban-rural, education etc.
Bruno Schoumaker
Centre for Demographic Research
Université catholique de Louvain
|
|
|
|
| Re: Afghanistan DHS [message #24532 is a reply to message #24531] |
Fri, 27 May 2022 03:24 |
schoumaker
Messages: 66
Registered: May 2013
Location: Belgium
|
Senior Member |
|
|
Hello again,
The syntax that Tom Pullum sent you a few days ago is better (and also provides confidence intervals).
Bruno
***
use AFIR71FL.DTA, clear
keep if v012>=15 & v012<=19
gene teenmom=0
replace teenmom=1 if v213==1|bidx_01==1
gen wt=v005/1000000
svyset [pw=wt], psu(v021) strata(v023) singleunit(centered)
gen awfact = awfactt/100
svy: ratio teenmom/awfact
Bruno Schoumaker
Centre for Demographic Research
Université catholique de Louvain
|
|
|
|
| Re: Afghanistan DHS [message #24540 is a reply to message #24530] |
Fri, 27 May 2022 12:51 |
Janet-DHS
Messages: 880
Registered: April 2022
|
Senior Member |
|
|
Following is response from DHS Research & Data Analysis Director, Tom Pullum:
If you open the AF file for women (the IR file) and then enter the following lines, you will get .1207. This is a proportion. Multiply it by 100 and then round to the nearest tenth of a percent and you get 12.1, which is the desired number.
gen teenmom=0 if v013==1
replace teenmom=1 if (v201>=1 | v213==1) & v013==1
svyset [pw=v005], psu(v021) strata(v023) singleunit(centered)
gen awfact = awfactt/100
svy: ratio teenmom/awfact
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
