Merging two datasets

[Muhammad Ramzan]

Hi I want to merge two datasets

I want to merge two data sets, every thing is set in two data sets expect the temp(first dataset) and rain rum(in the second dataset)


I am trying to merge using id_g but getting the not uniquely identified

* Example generated by -dataex-. To install: ssc install dataex
clear
input double(lat longitude) int Year byte month float date long ID double temp float id_g
-179.75 -89.75 1951  1 -108 20 -28.2 1
-179.75 -89.75 1951  2 -107 20 -40.7 1
-179.75 -89.75 1951  3 -106 20 -53.7 1
-179.75 -89.75 1951  4 -105 20 -56.1 1
-179.75 -89.75 1951  5 -104 20   -57 1
-179.75 -89.75 1951  6 -103 20 -59.2 1
-179.75 -89.75 1951  7 -102 20 -60.1 1
-179.75 -89.75 1951  8 -101 20 -58.6 1
-179.75 -89.75 1951  9 -100 20 -62.6 1
-179.75 -89.75 1951 10  -99 20 -50.4 1
-179.75 -89.75 1951 11  -98 20 -36.9 1
-179.75 -89.75 1951 12  -97 20 -27.2 1
-179.75 -89.25 1951  1 -108 19 -28.5 2
-179.75 -89.25 1951  2 -107 19   -41 2
-179.75 -89.25 1951  3 -106 19 -53.7 2
-179.75 -89.25 1951  4 -105 19 -56.7 2
-179.75 -89.25 1951  5 -104 19 -57.4 2
-179.75 -89.25 1951  6 -103 19 -59.4 2
-179.75 -89.25 1951  7 -102 19 -60.7 2
-179.75 -89.25 1951  8 -101 19 -58.8 2
-179.75 -89.25 1951  9 -100 19 -62.8 2
-179.75 -89.25 1951 10  -99 19 -50.5 2
-179.75 -89.25 1951 11  -98 19 -36.7 2
-179.75 -89.25 1951 12  -97 19 -27.4 2
-179.75 -88.75 1951  1 -108 18 -28.6 3
-179.75 -88.75 1951  2 -107 18   -41 3
-179.75 -88.75 1951  3 -106 18 -53.6 3
-179.75 -88.75 1951  4 -105 18 -56.9 3
-179.75 -88.75 1951  5 -104 18 -57.4 3
-179.75 -88.75 1951  6 -103 18 -59.3 3
-179.75 -88.75 1951  7 -102 18 -60.9 3
-179.75 -88.75 1951  8 -101 18 -58.8 3
-179.75 -88.75 1951  9 -100 18 -62.8 3
-179.75 -88.75 1951 10  -99 18 -50.3 3
-179.75 -88.75 1951 11  -98 18 -36.5 3
-179.75 -88.75 1951 12  -97 18 -27.6 3
-179.75 -88.25 1951  1 -108 17 -28.5 4
-179.75 -88.25 1951  2 -107 17 -40.7 4
-179.75 -88.25 1951  3 -106 17 -53.1 4
-179.75 -88.25 1951  4 -105 17 -56.6 4
-179.75 -88.25 1951  5 -104 17   -57 4
-179.75 -88.25 1951  6 -103 17 -58.9 4
-179.75 -88.25 1951  7 -102 17 -60.7 4
-179.75 -88.25 1951  8 -101 17 -58.4 4
-179.75 -88.25 1951  9 -100 17 -62.4 4
-179.75 -88.25 1951 10  -99 17 -49.8 4
-179.75 -88.25 1951 11  -98 17 -36.2 4
-179.75 -88.25 1951 12  -97 17 -27.5 4
-179.75 -87.75 1951  1 -108 16 -27.9 5
-179.75 -87.75 1951  2 -107 16 -39.9 5
-179.75 -87.75 1951  3 -106 16   -52 5
-179.75 -87.75 1951  4 -105 16 -55.6 5
-179.75 -87.75 1951  5 -104 16   -56 5
-179.75 -87.75 1951  6 -103 16 -57.9 5
-179.75 -87.75 1951  7 -102 16 -59.8 5
-179.75 -87.75 1951  8 -101 16 -57.6 5
-179.75 -87.75 1951  9 -100 16 -61.3 5
-179.75 -87.75 1951 10  -99 16 -48.8 5
-179.75 -87.75 1951 11  -98 16 -35.4 5
-179.75 -87.75 1951 12  -97 16 -26.9 5
-179.75 -87.25 1951  1 -108 15 -27.5 6
-179.75 -87.25 1951  2 -107 15 -39.1 6
-179.75 -87.25 1951  3 -106 15 -51.2 6
-179.75 -87.25 1951  4 -105 15 -54.8 6
-179.75 -87.25 1951  5 -104 15   -55 6
-179.75 -87.25 1951  6 -103 15 -56.9 6
-179.75 -87.25 1951  7 -102 15 -59.1 6
-179.75 -87.25 1951  8 -101 15 -56.9 6
-179.75 -87.25 1951  9 -100 15 -60.5 6
-179.75 -87.25 1951 10  -99 15 -47.9 6
-179.75 -87.25 1951 11  -98 15 -34.6 6
-179.75 -87.25 1951 12  -97 15 -26.5 6
-179.75 -86.75 1951  1 -108 14 -26.8 7
-179.75 -86.75 1951  2 -107 14 -38.3 7
-179.75 -86.75 1951  3 -106 14   -50 7
-179.75 -86.75 1951  4 -105 14   -54 7
-179.75 -86.75 1951  5 -104 14 -54.1 7
-179.75 -86.75 1951  6 -103 14 -56.2 7
-179.75 -86.75 1951  7 -102 14 -58.3 7
-179.75 -86.75 1951  8 -101 14 -55.9 7
-179.75 -86.75 1951  9 -100 14 -59.4 7
-179.75 -86.75 1951 10  -99 14 -46.9 7
-179.75 -86.75 1951 11  -98 14 -33.7 7
-179.75 -86.75 1951 12  -97 14 -25.9 7
-179.75 -86.25 1951  1 -108 13 -25.6 8
-179.75 -86.25 1951  2 -107 13 -36.8 8
-179.75 -86.25 1951  3 -106 13 -48.3 8
-179.75 -86.25 1951  4 -105 13 -52.4 8
-179.75 -86.25 1951  5 -104 13 -52.3 8
-179.75 -86.25 1951  6 -103 13 -54.6 8
-179.75 -86.25 1951  7 -102 13 -56.8 8
-179.75 -86.25 1951  8 -101 13 -54.6 8
-179.75 -86.25 1951  9 -100 13 -57.8 8
-179.75 -86.25 1951 10  -99 13 -45.3 8
-179.75 -86.25 1951 11  -98 13 -32.3 8
-179.75 -86.25 1951 12  -97 13 -24.8 8
-179.75 -85.75 1951  1 -108 12 -24.2 9
-179.75 -85.75 1951  2 -107 12   -35 9
-179.75 -85.75 1951  3 -106 12 -45.8 9
-179.75 -85.75 1951  4 -105 12 -50.1 9
end
format %tm date

second dataset

* Example generated by -dataex-. To install: ssc install dataex
clear
input float(lat longitude) int year byte month long id float(rain sum id_g)
-179.75 -89.75 1951  1 20   63 183.8 1
-179.75 -89.75 1951  2 20 42.3 183.8 1
-179.75 -89.75 1951  3 20    0 183.8 1
-179.75 -89.75 1951  4 20    0 183.8 1
-179.75 -89.75 1951  5 20    0 183.8 1
-179.75 -89.75 1951  6 20 56.5 183.8 1
-179.75 -89.75 1951  7 20    0 183.8 1
-179.75 -89.75 1951  8 20  9.9 183.8 1
-179.75 -89.75 1951  9 20  2.4 183.8 1
-179.75 -89.75 1951 10 20    0 183.8 1
-179.75 -89.75 1951 11 20  8.8 183.8 1
-179.75 -89.75 1951 12 20   .9 183.8 1
-179.75 -89.25 1951  1 19 63.4 186.6 2
-179.75 -89.25 1951  2 19 42.4 186.6 2
-179.75 -89.25 1951  3 19    0 186.6 2
-179.75 -89.25 1951  4 19  1.7 186.6 2
-179.75 -89.25 1951  5 19    0 186.6 2
-179.75 -89.25 1951  6 19 56.4 186.6 2
-179.75 -89.25 1951  7 19    0 186.6 2
-179.75 -89.25 1951  8 19  9.7 186.6 2
-179.75 -89.25 1951  9 19  2.1 186.6 2
-179.75 -89.25 1951 10 19    0 186.6 2
-179.75 -89.25 1951 11 19  8.5 186.6 2
-179.75 -89.25 1951 12 19  2.4 186.6 2
-179.75 -88.75 1951  1 18 63.9 185.8 3
-179.75 -88.75 1951  2 18 42.5 185.8 3
-179.75 -88.75 1951  3 18    0 185.8 3
-179.75 -88.75 1951  4 18  1.1 185.8 3
-179.75 -88.75 1951  5 18    0 185.8 3
-179.75 -88.75 1951  6 18 57.1 185.8 3
-179.75 -88.75 1951  7 18    0 185.8 3
-179.75 -88.75 1951  8 18  9.4 185.8 3
-179.75 -88.75 1951  9 18  1.8 185.8 3
-179.75 -88.75 1951 10 18    0 185.8 3
-179.75 -88.75 1951 11 18  8.2 185.8 3
-179.75 -88.75 1951 12 18  1.8 185.8 3
-179.75 -88.25 1951  1 17 64.4 185.7 4
-179.75 -88.25 1951  2 17 42.7 185.7 4
-179.75 -88.25 1951  3 17    0 185.7 4
-179.75 -88.25 1951  4 17   .7 185.7 4
-179.75 -88.25 1951  5 17    0 185.7 4
-179.75 -88.25 1951  6 17 57.7 185.7 4
-179.75 -88.25 1951  7 17    0 185.7 4
-179.75 -88.25 1951  8 17  9.1 185.7 4
-179.75 -88.25 1951  9 17  1.6 185.7 4
-179.75 -88.25 1951 10 17    0 185.7 4
-179.75 -88.25 1951 11 17  8.1 185.7 4
-179.75 -88.25 1951 12 17  1.4 185.7 4
-179.75 -87.75 1951  1 16 65.1 187.9 5
-179.75 -87.75 1951  2 16 43.4 187.9 5
-179.75 -87.75 1951  3 16    0 187.9 5
-179.75 -87.75 1951  4 16   .7 187.9 5
-179.75 -87.75 1951  5 16    0 187.9 5
-179.75 -87.75 1951  6 16 58.4 187.9 5
-179.75 -87.75 1951  7 16    0 187.9 5
-179.75 -87.75 1951  8 16  8.9 187.9 5
-179.75 -87.75 1951  9 16  1.4 187.9 5
-179.75 -87.75 1951 10 16    0 187.9 5
-179.75 -87.75 1951 11 16  8.6 187.9 5
-179.75 -87.75 1951 12 16  1.4 187.9 5
-179.75 -87.25 1951  1 15 66.2 193.7 6
-179.75 -87.25 1951  2 15 44.7 193.7 6
-179.75 -87.25 1951  3 15    0 193.7 6
-179.75 -87.25 1951  4 15  1.2 193.7 6
-179.75 -87.25 1951  5 15    0 193.7 6
-179.75 -87.25 1951  6 15 59.1 193.7 6
-179.75 -87.25 1951  7 15    0 193.7 6
-179.75 -87.25 1951  8 15  8.8 193.7 6
-179.75 -87.25 1951  9 15  1.4 193.7 6
-179.75 -87.25 1951 10 15    0 193.7 6
-179.75 -87.25 1951 11 15 10.2 193.7 6
-179.75 -87.25 1951 12 15  2.1 193.7 6
-179.75 -86.75 1951  1 14 67.1 199.1 7
-179.75 -86.75 1951  2 14 45.9 199.1 7
-179.75 -86.75 1951  3 14    0 199.1 7
-179.75 -86.75 1951  4 14  1.7 199.1 7
-179.75 -86.75 1951  5 14    0 199.1 7
-179.75 -86.75 1951  6 14 59.5 199.1 7
-179.75 -86.75 1951  7 14    0 199.1 7
-179.75 -86.75 1951  8 14  8.7 199.1 7
-179.75 -86.75 1951  9 14  1.4 199.1 7
-179.75 -86.75 1951 10 14    0 199.1 7
-179.75 -86.75 1951 11 14 11.9 199.1 7
-179.75 -86.75 1951 12 14  2.9 199.1 7
-179.75 -86.25 1951  1 13 67.7   204 8
-179.75 -86.25 1951  2 13 47.1   204 8
-179.75 -86.25 1951  3 13    0   204 8
-179.75 -86.25 1951  4 13  2.4   204 8
-179.75 -86.25 1951  5 13    0   204 8
-179.75 -86.25 1951  6 13 59.6   204 8
-179.75 -86.25 1951  7 13    0   204 8
-179.75 -86.25 1951  8 13  8.3   204 8
-179.75 -86.25 1951  9 13  1.3   204 8
-179.75 -86.25 1951 10 13    0   204 8
-179.75 -86.25 1951 11 13 13.8   204 8
-179.75 -86.25 1951 12 13  3.8   204 8
-179.75 -85.75 1951  1 12 68.2   210 9
-179.75 -85.75 1951  2 12 48.3   210 9
-179.75 -85.75 1951  3 12    0   210 9
-179.75 -85.75 1951  4 12  3.7   210 9
end

[Clyde Schechter]

use first_dataset, clear
rename Year year
merge 1:1 id_g month year using second_dataset

[Muhammad Ramzan]

Clyde Schechter

Thanks

[Muhammad Ramzan]

@Clyde Schechter

is there any option in merge that someone wants to include only x1 x2 variables from the second data (using ) dataset?


thanks

[Clyde Schechter]

Yes. Add the -keepusing(x1 x2)- option to your -merge- command if you only want to keep x1 and x2 from there.