I have a panel data set (Master) with id, name, month, and year.

I have another data set (Data set 2) with multiple ids (id, id1, id2 etc).

I am trying to merge the two data sets by common variable "id".

Any help is much appreciated.


Master panel data set:

----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input double id str40 name double(year month)
  519 "Peconic "  2012  6
  692 "Giano "                  2013  6
25643 ""                                        2013  6
31725 "Cedarview "   2012  6
16835 "Havens "        2012  3
16835 "Havens "        2012  6
16835 "Havens "        2012  9
16835 "Havens "        2012 12
16835 "Havens "        2013  3
16835 "Havens "        2013  6
16835 "Havens "        2013  9
16835 "Havens "        2013 12
16835 "Havens "        2014  3
16835 "Havens "        2014  6
16835 "Havens "        2014  9
16835 "Havens "        2014 12
16835 "Havens "        2015  3
16835 "Havens "        2015  6
29459 "Dynamic "                  2012  6
29201 "Round "            2012  3
29201 "Round "            2012  6
29201 "Round "            2012  9
29201 "Round "            2012 12
29201 "Round "            2013  3
29201 "Round "            2013  6
29201 "Round "            2013  9
29201 "Round "            2013 12
29201 "Round "            2014  3
29201 "Round "            2014  6
29201 "Round "            2014  9
29201 "Round "            2014 12
29201 "Round "            2015  3
29201 "Round "            2015  6
26920 "BCM "        2012  6
 7188 "Crestline "                   2012  3
 7188 "Crestline "                   2012  6
 7188 "Crestline "                   2012  9
 7188 "Crestline "                   2012 12
 7188 "Crestline "                   2013  3
 7188 "Crestline "                   2013  6
 7188 "Crestline "                   2013  9
 7188 "Crestline "                   2013 12
 7188 "Crestline "                   2014  3
 7188 "Crestline "                   2014  6
 7188 "Crestline "                   2014  9
 7188 "Crestline "                   2014 12
 7188 "Crestline "                   2015  3
 7188 "Crestline "                   2015  6
30928 "Cambridge " 2012  3
30928 "Cambridge " 2012  6
30928 "Cambridge " 2012  9
30928 "Cambridge " 2012 12
30928 "Cambridge " 2013  3
30928 "Cambridge " 2013  6
30928 "Cambridge " 2013  9
30928 "Cambridge " 2013 12
30928 "Cambridge " 2014  3
30928 "Cambridge " 2014  6
30928 "Cambridge " 2014  9
30928 "Cambridge " 2014 12
30928 "Cambridge " 2015  3
30928 "Cambridge " 2015  6
26884 "Teton "             2012  3
26884 "Teton "             2012  6
26884 "Teton "             2012  9
26884 "Teton "             2012 12
26884 "Teton "             2013  3
26884 "Teton "             2013  6
26884 "Teton "             2013  9
26884 "Teton "             2013 12
26884 "Teton "             2014  3
26884 "Teton "             2014  6
26884 "Teton "             2014  9
26884 "Teton "             2014 12
26884 "Teton "             2015  3
26884 "Teton "             2015  6
 9673 "Silver "                      2012  3
 9673 "Silver "                      2012  6
 9673 "Silver "                      2012  9
 9673 "Silver "                      2012 12
 9673 "Silver "                      2013  3
 9673 "Silver "                      2013  6
 9673 "Silver "                      2013  9
 9673 "Silver "                      2013 12
 9673 "Silver "                      2014  3
 9673 "Silver "                      2014  6
 9673 "Silver "                      2014  9
 9673 "Silver "                      2014 12
 9673 "Silver "                      2015  3
 9673 "Silver "                      2015  6
28879 "Insignia "                 2012  3
28879 "Insignia "                 2012  6
28879 "Insignia "                 2012  9
28879 "Insignia "                 2012 12
28879 "Insignia "                 2013  3
28879 "Insignia "                 2013  6
28879 "Insignia "                 2013  9
28879 "Insignia "                 2013 12
28879 "Insignia "                 2014  3
28879 "Insignia "                 2014  6
end
------------------ copy up to and including the previous line ------------------


Data Set 2: Id data set:

----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input double(id id1 id2)
  3   5     .
  5   9     .
  9  13     .
 10  14     .
 11  15     .
 12  16     .
 13  18     .
 14  19     .
 15  21     .
 17  26     .
 18  28     .
 19  29     .
 20  30     .
 22  32     .
 24  34     .
 25  35     .
 26  37     .
 27  38     .
 28  39     .
 29  41     .
 30  44     .
 32  46     .
 33  47     .
 35  53     .
 36  54     .
 37  55     .
 38  56     .
 39  57     .
 40  59     .
 41  60     .
 42  61     .
 43  62     .
 45  64     .
 50  72     .
 51  74     .
 52  78 36729
 53  79     .
 55  81     .
 56  82     .
 57  84     .
 61  90     .
 62  91     .
 63  92     .
 64  93     .
 65  94     .
 66  95     .
 67  96     .
 68  97     .
 69  98     .
 70  99     .
 71 100     .
 72 101     .
 73 103     .
 74 104     .
 75 105     .
 76 113     .
 77 114     .
 78 116     .
 79 118     .
 80 119     .
 81 131     .
 83 140     .
 84 141     .
 85 142     .
 86 143     .
 88 161     .
 89 164 89516
 90 165     .
 91 166     .
 94 171     .
 96 175     .
 97 180     .
 98 181     .
 99 182     .
100 183     .
101 184     .
102 185     .
103 192     .
104 193     .
107 200     .
108 201     .
109 202     .
110 203     .
111 204     .
112 205     .
113 209     .
116 217     .
117 222 70762
119 225     .
120 226     .
121 228   251
123 234     .
124 236     .
125 237     .
126 238     .
131 245     .
132 248     .
135  66   256
137 260     .
138 261     .
end
------------------ copy up to and including the previous line ------------------