The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » India » Creating an unbalanced panel
Re: Creating an unbalanced panel [message #18522 is a reply to message #18517] Mon, 16 December 2019 10:08 Go to previous messageGo to previous message
Niranjana is currently offline  Niranjana
Messages: 13
Registered: October 2019
Member
Thank you for the response Tom.

I was looking to create a dataset with multiple entries per woman depending on the number of children she has with the exact same variables as would be present in the IR file for the year. Except now with instead of multiple columns for each child (as in IR), the dataset will be long with multiple rows per woman and her birth history.

This is what I meant by an unbalanced panel -- the woman enters the panel at the time of marriage with year entries for each birth and exits the panel on the year of interview. I reviewed BR files and the data seems to represent exactly what I was looking for.

Do you think it would be wise if I were to append multiple waves of the NFHS BR datasets? Are the caseid variables unique across each wave? using -duplicates report caseid- shows that some caseids are reported over 20 times even though the max number of children recorded is 18 for NFHS I AND II.


Thanks so much for the help, Bridgette and Tom!
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Appending multiple waves of the NFHS annd PSU codes
Next Topic: NFHS III and IV comparability of slum and non-slum data among 8 major cities, India
Goto Forum:
  


Current Time: Sun Apr 28 08:58:02 Coordinated Universal Time 2024