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)
Very different SEs with table vs mean when there are missing values and pweightsStata version: 17 I ran the new table command with the statistic(semean varlist) option. The result…
bar graph positionHi Anybody can help me with how to fix the graph position. < graph hbar (mean) group_0 group_1 i…
Long categories labels in graph hbarDear Stata users, I encounter this question when I graph hbar. Value labels of my category variable…
Headings for coefplot graph but want to exclude ref category for categorical variablesHi all, I am using coefplot to create a graph of ORs for odds of contraceptive discontinuation by me…
How can I report p value with asdoc and xtregDear all, I am struggeling with getting the p value in word using asdoc and xtreg. - i tried to us…
Subscribe to:
Post Comments (Atom)
0 Response to Merge two data set? (particular case)
Post a Comment