Hey guys,

Is there an easy way how to combine two tables with identical variables in a long format? I know the way to do it in R, but I'm relatively new to STATA.

something like


Code:
country year Mtradevalues Xtradevalues reporter
DE 2006 1210361 19155.856 BGR
FR 2006 1930305 23593.872 BGR
PT 2006 2396189 15831.303 BGR
HU 2006 2180976 38385.497 BGR
DE 2007 4231964 28908270 BGR
FR 2007 4605479 51528.886 BGR
PT 2007 5494027 32150.922 BGR
HU 2007 6568278 22475.737 BGR

with

Code:
country year Mtradevalues Xtradevalues reporter
DE 2006 51321281 22475.737 CAN
FR 2006 890429 16259.211 CAN
PT 2006 5754045 15831.303 CAN
HU 2006 6443940 15831.303 CAN
DE 2007 8168050 16259.211 CAN
FR 2007 1321281 22475.737 CAN
PT 2007 1598655 23593.872 CAN
HU 2007 1300962 19155.856 CAN

to


Code:
country year Mtradevalues Xtradevalues reporter
DE 2006 1210361 19155.856 BGR
FR 2006 1930305 23593.872 BGR
PT 2006 2396189 15831.303 BGR
HU 2006 2180976 38385.497 BGR
DE 2007 4231964 28908270 BGR
FR 2007 4605479 51528.886 BGR
PT 2007 5494027 32150.922 BGR
HU 2007 6568278 22475.737 BGR
DE 2006 51321281 22475.737 CAN
FR 2006 890429 16259.211 CAN
PT 2006 5754045 15831.303 CAN
HU 2006 6443940 15831.303 CAN
DE 2007 8168050 16259.211 CAN
FR 2007 1321281 22475.737 CAN
PT 2007 1598655 23593.872 CAN
HU 2007 1300962 19155.856 CAN

Many thanks in advance