The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in Stata » Extracting Zimbabwe households with at least 1 birth in last 2 years
Extracting Zimbabwe households with at least 1 birth in last 2 years [message #2718] Thu, 14 August 2014 19:10 Go to next message
swdalb is currently offline  swdalb
Messages: 5
Registered: August 2014
Member
Hi everyone,

I am working with the ZWBR62DT.dta data - so the Zim 2011 DHS STATA data - and I want to extract data on contraceptive use from any woman in a household where at least one woman in that household has had a birth in the 2 years prior to the survey. The only available data for Zim 2011 is BR, KR, GE and HR, so I'm not sure which one I should use to get all of this data. I don't think that the BR dataset contains any information on women in households that haven't had births because... this is a birth level dataset, but I'm also not sure that any of the other datasets have the variables I'm interested in (contraceptive use / modern contraceptive use). Could someone please advise me on (1) which dataset to use and (2) how to extract this information? Thanks so much.

-Sean
Re: Extracting Zimbabwe households with at least 1 birth in last 2 years [message #2722 is a reply to message #2718] Fri, 15 August 2014 01:49 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 787
Registered: January 2013
Senior Member
Hi Sean,
1) First you need to decide on what your unit of analysis will be - that usually determines the dataset to use. It sounds like you will be analyzing women, so you should use a file that has women as the unit of analysis, and you are right that the BR dataset is the wrong file - you should use the IR file.
2) Second you need to select which women to include in your analysis. If you are interested in analyzing women who gave birth in the last two years, then you need to look at the date of the last birth compared to the date of interview. v008 is the century month code (cmc) of the date of interview and b3_01 is the cmc of the date of the last birth, thus you should women with the following if clause:

if v008 - b3_01 < 24

Re: Extracting Zimbabwe households with at least 1 birth in last 2 years [message #2726 is a reply to message #2722] Fri, 15 August 2014 11:34 Go to previous message
swdalb is currently offline  swdalb
Messages: 5
Registered: August 2014
Member
Hi Trevor,

Thanks for the response. Good to know about the CMC data too - I had been conditioning on day / month / year of interview and birth day, so it was needlessly complicated it seems. Thanks again!

-Sean
Previous Topic: Replicating vaccination rate
Next Topic: survey set preparation for Pakistan DHS 2012-13
Goto Forum:
  


Current Time: Thu Mar 28 12:24:37 Coordinated Universal Time 2024