I’m trying to tabulate voting and volunteering behaviors by income decile. To do that, I’m trying to take the household income information (hhincome) from the March survey, and spread it to the households in the September and November supplements. Right now, I’m just using the “serial” identifier to do that. Here’s my stata command:
egen hhincome2 = max(hhincome), by(serial)
I’m hoping that the “hhincome2” variable spreads the March household income information to the same households in the September and November supplements. I should mention that I’m doing this separately for the September and November supplements.
Is that all kosher? If not, how can I attach income data to the people in the September and November supplements?
If it is kosher, how should I weight my final tabulations. Any help (and patience with this newbie) would be much appreciated. Let me know if I can clarify my question, too.