The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Creating unique household id in Women's data
Re: Creating unique household id in Women's data [message #11591 is a reply to message #11581] Fri, 13 January 2017 07:55 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3216
Registered: February 2013
Senior Member
Following is a response from Senior DHS Stata Specialist, Tom Pullum:

Quote:
In that example, the household has two women, who are on lines 4 and 7. The hhid is a combination of cluster id (hv001 or v001) and household id (hv002 or v002). (The line number is hvidx or v003.)

Most households will have one eligible respondent--if they have any at all. Only a few will have more than one. You will use up all your degrees of freedom if you have fixed effects for household. I would not even try random effects for households. The density of women per household is too low. Fixed or random effects for cluster would be as far down into the data as I would go.

You would definitely use "xi." for fixed effects--no need to construct dummy variables (fortunately!). For random effects, use an "me" model.

However, we really cannot advise on your choice of model, just on data-related issues and to a limited degree on Stata syntax.

 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Child's weight in Kg (1 decimal) variable in SAS
Next Topic: Merging mother's data with children's data in SAS
Goto Forum:
  


Current Time: Fri Jan 3 03:09:12 Coordinated Universal Time 2025