Dear
Gretl community,
I have two datasets A and B. Both A and B have
different variables but with common variable i.e. ID. I want to merge these two data sets using ID as the common variable as given below : data set C. Thanking you in advanceI would be thankful for providing the solution. Note: A :
Household data and B members data.
Dhanasekaran K
|
ID |
x1 |
x2 |
x3 |
|
1 |
50 |
2 |
1 |
|
2 |
60 |
5 |
3 |
|
3 |
30 |
6 |
5 |
|
4 |
20 |
9 |
6 |
|
5 |
90 |
7 |
9 |
data set:B
|
ID |
x4 |
x5 |
|
1 |
5 |
male |
|
1 |
4 |
female |
|
1 |
3 |
male |
|
2 |
2 |
male |
|
2 |
5 |
female |
|
3 |
6 |
male |
|
3 |
1 |
female |
|
3 |
8 |
female |
|
4 |
2 |
male |
|
5 |
3 |
female |
|
5 |
10 |
male |
merged data set: C
|
ID |
x1 |
x2 |
x3 |
x4.1 |
x4.2 |
x4.3 |
x5.1 |
x5.2 |
x5.3 |
|
1 |
50 |
2 |
1 |
5 |
4 |
3 |
male |
female |
male |
|
2 |
60 |
5 |
3 |
2 |
5 |
NA |
male |
female |
NA |
|
3 |
30 |
6 |
5 |
6 |
1 |
8 |
male |
female |
female |
|
4 |
20 |
9 |
6 |
2 |
NA |
NA |
male |
NA |
NA |
|
5 |
90 |
7 |
9 |
3 |
10 |
NA |
female |
male |
NA |