I am using a dataset divided into several different files, some of those are at the household level and some at the individual level. I want to work at the individual level but having information from the households too, but I am having problem merging files with two different levels. Households are identified by a code, let's say "hhid", and individual by both households and individual code "indid".
Just to show an example:
hh.dta
hhid
1
2
3
4
ind.dta
hhid indid
1 1
1 2
2 1
3 1
4 1
4 2
4 3
How can I merge the two files, in a way in which the variable of the household is matched to all individuals in that household?
I hope my question is enough clear, thanks!
Related Posts with Merge households and individuals datasets
Very large variance in PROBIT regressionhi, I had a problem with the variance when I run IVPROBIT regression. I have a number of binary vari…
Distribution of individual fixed effectsHi there, I am running a panel regression model using the 'reghdfe'-command with high-dimensional f…
Clustering of SEs: Heteroskedasticity and AutocorrelationI am running a panel data analysis of geographic diversification (quadratic) on company performance …
Help with collinearityHello Statalist, I'm relatively new to STATA and I'm working on a research project on education lev…
xtivreg, re firstHello. I have a question about the first stage regression in xtivreg, re. I assume it should possib…
Subscribe to:
Post Comments (Atom)
0 Response to Merge households and individuals datasets
Post a Comment