Stata Technical Bulletin
|
order |
x |
У |
_merge | |
|
1. |
1 |
1.605509 |
-1.849471 |
3 |
|
2. |
2 |
-1.363875 |
.4429037 |
3 |
|
3. |
3 |
1.255479 |
2.122414 |
3 |
|
4. |
4 |
.6902485 |
.3309246 |
3 |
|
5. |
5 |
.7910749 |
-.6871347 |
3 |
|
6. |
6 |
-1.067126 |
1.272875 |
3 |
|
7. |
7 |
1.471047 |
-.4236486 |
3 |
|
8. |
8 |
-1.971935 |
-1.741924 |
3 |
|
9. |
9 |
1.805707 |
-.4869484 |
3 |
|
10. |
10 |
-.5496167 |
.7764114 |
3 |
mergedct can also merge the same data stored in a raw, rather than a dictionary, file:
. use dta, clear
. type inrawl.raw
10 .7764114
1 -1.849471
2 .4429037
3 2.122414
4 .3309246
5 -.6871347
6 1.272875
7 -.4236486
8 -1.741924
9 -.4869484
. mergedct order using Inrawl, vlist(order y)
. list
|
order |
x |
У |
_merge | |
|
1. |
1 |
1.605509 |
-1.849471 |
3 |
|
2. |
2 |
-1.363875 |
.4429037 |
3 |
|
3. |
3 |
1.255479 |
2.122414 |
3 |
|
4. |
4 |
.6902485 |
.3309246 |
3 |
|
5. |
5 |
.7910749 |
-.6871347 |
3 |
|
6. |
6 |
-1.067126 |
1.272875 |
3 |
|
7. |
7 |
1.471047 |
-.4236486 |
3 |
|
8. |
8 |
-1.971935 |
-1.741924 |
3 |
|
9. |
9 |
1.805707 |
-.4869484 |
3 |
|
10. |
10 |
-.5496167 |
.7764114 |
3 |
mergedct can handle match merging as well:
. use dta, clear
. type indict2.dct
dictionary {
int z
}
101
102
103
104
105
106
107
108
109
110
. mergedct using indict2
. list
|
order |
x |
z |
_merge | |
|
1. |
1 |
1.605509 |
101 |
3 |
|
2. |
2 |
-1.363875 |
102 |
3 |
|
3. |
3 |
1.255479 |
103 |
3 |
|
4. |
4 |
.6902485 |
104 |
3 |
|
5. |
5 |
.7910749 |
105 |
3 |
|
6. |
6 |
-1.067126 |
106 |
3 |
|
7. |
7 |
1.471047 |
107 |
3 |
|
8. |
8 |
-1.971935 |
108 |
3 |
|
9. |
9 |
1.805707 |
109 |
3 |
|
10. |
10 |
-.5496167 |
110 |
3 |