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,