The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Fertility » Place of delivery variables m15_1 and m15_2
Place of delivery variables m15_1 and m15_2 [message #11615] Tue, 17 January 2017 05:55
priyoma is currently offline  priyoma
Messages: 7
Registered: January 2017
Member
Hey,
I am using the IAIR42FL dataset ie the women's dataset for India based on NFHS Round II.
In section 4A : ANTENATAL, NATAL, AND POSTNATAL CARE of the questionnaire, there are questions asked about most two recent births post Jan,1995.

One of the questions are about place of delivery and the corresponding variables in the dataset are m15_1 and m15_2 for the two children.

Since the data is cross-sectional, and after I reshaped a dataset containing only caseid ,m15_1 and m15_2 into the long format I have three columns such as caseid m15 and year which is either 1 and 2. But for this I cannot get the year of birth of these two children.

In another dataset with all the birth history variables ie bidx, bord, b1 till b15 I have their year of birth b2. How can I merge these two datasets, in order the get the year of birth of these two children, their place of delivery and the caseid of the mother?


Can you please give me a stata code for it, describing everything if I have to make some other dataset,reshape something else or anything else which gives me a dataset as follows:

caseid year of birth place of delivery

21341 1995 respondent's home
21341 1998 govt hospital


Regards
Previous Topic: Fertility Indicator
Next Topic: Birth weight variables
Goto Forum:
  


Current Time: Fri Aug 12 04:32:18 Coordinated Universal Time 2022