I have the following data. In Data set A, I have rows of children with "h13hhidc" indicating their household ID including the relevant sub-household ID information. "h13hhidc" is not unique to the children since multiple children of the same household are found within the data. Data Set B includes parents (some single households and some married households). These are also uniquely identified by h13hhidc. I would like to merge Data A and Data B so that the final result includes all parents in Data B having a new row for each child present in Data A, that has a matching h13hhidc. I want to keep people in Data B that do not have children in Data A (as a I later have more child data sets to import), but again, have several lines for parents that did in fact have matching children in Data A.
I have searched the forum and feel like this would be the proper time for the joinby command, but I am not getting the desired result. Any help is greatly appreciated.
Data A
Data B
I have searched the forum and feel like this would be the proper time for the joinby command, but I am not getting the desired result. Any help is greatly appreciated.
Data A
Code:
. list hhid opn h13hhidc psubhh qsubhh education in 1/500 , sepby (hhid)
+------------------------------------------------------+
| hhid opn h13hhidc psubhh qsubhh educat~n |
|------------------------------------------------------|
1. | 010004 101 0100040 0 0 . |
2. | 010004 201 0100040 0 0 . |
3. | 010004 202 0100040 0 0 . |
4. | 010004 604 0100040 0 0 . |
5. | 010004 605 0100040 0 0 . |
Code:
. list hhid pn h13hhidc in 6/20, sepby (hhid)
+-------------------------+
| hhid pn h13hhidc |
|-------------------------|
6. | 010003 020 . |
7. | 010003 030 0100030 |
|-------------------------|
8. | 010004 010 . |
9. | 010004 040 0100040 |
|-------------------------|
10. | 010013 010 . |
11. | 010013 040 0100131 |
|-------------------------|
12. | 010038 010 0100380 |
13. | 010038 040 0100380
