The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Malaria » Prevention of malaria in pregnant women with Fansidar (calculate the variable on women aged 15-49 years who had a live birth in the 2 years before the survey using TOGO malaria indicator survey 2017)
Re: Prevention of malaria in pregnant women with Fansidar [message #23890 is a reply to message #23888] Thu, 30 December 2021 09:36 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member

Following is another response from DHS Research & Data Analysis Director, Tom Pullum:

My code was designed for the IR file. In the KR file, there is one record for each child, and the mother's data is copied onto each of them. You want to know the number of women who had a birth (i.e. at least one birth) in the past 24 months. Here is a simple way to get that:

use "...TGKR71FL.DTA" , clear
gen wt=v005/1000000
keep if b19<24
egen sequence=seq(), by(v001 v002 v003)
keep if sequence==1
total wt

This gives a weighted total of 1315, which agrees with the much more general approach that I used with the IR file.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Malaria in pregnancy-DHS-VI SPSS version
Next Topic: HML10
Goto Forum:
  


Current Time: Tue Nov 26 05:31:12 Coordinated Universal Time 2024