Hi everyone,
I am struggling with how I should merge two datasets. The dataset contains respondents, who have provided information on the household (applicable to the whole household) plus few information on the household members. However, these information (age, sex, primary occupation,...) on members are to be found in an other table. So I would like to merge these two tables based on the respondent name which is the same accross household members and turn household members' information into attribute of each household observation (identified by respondent name) such as member1_sex, member 1_age,... member2_sex, member2_age,...
All of this knowing the number of member is varying across households... Each household member being identified by its own name!
Thanks a lot for your answers,
Related Posts with Merge two data set? (particular case)
Remove estimated parameters from Stata result windowHi All, just a quick question. I am estimating a model containing a lot of dummies, which I use as …
Nobel Prize in Economics 2021The Nobel Prize is awarded to David Card, Joshua Angrist, and Guido Imbens. These men popularized th…
comparing data when one observation is recorded more than onceSorry about the barrage of questions but I am struggling with this. I have a file which look like th…
Compare variable in two stata files and listI have two datasets and I want to make sure that the same IDnumber has not been recorded twice in th…
Difficulty interpreting results (xtlogit in combination with marginal effects)Hi, I ran the following command on my panel data: Code: xtlogit A B C D E F G logH And got the fo…
Subscribe to:
Post Comments (Atom)
0 Response to Merge two data set? (particular case)
Post a Comment