Hello Statalisters,
I apologize if it is a question already been asked (and solved, hopefully). I have two datasets that I want to merge, but I have a problem sprouting mainly from the way the data is structured.
In one data set I have, what most datasets look like:
Country year score
X 1998 5
X 1999 4
Y 1998 5
Y 1999 3
and so forth. The other dataset, however, has multiple observations per year.
Country Year aid agency
X 1999 2000 UN
X 1999 3000 World Bank
X 1999 3500 IMF
The question now is how do I merge the two datasets? Since I cannot xtset the latter dataset, the conventional way of merging datasets failed me.
Thanks for your time,
BA
I apologize if it is a question already been asked (and solved, hopefully). I have two datasets that I want to merge, but I have a problem sprouting mainly from the way the data is structured.
In one data set I have, what most datasets look like:
Country year score
X 1998 5
X 1999 4
Y 1998 5
Y 1999 3
and so forth. The other dataset, however, has multiple observations per year.
Country Year aid agency
X 1999 2000 UN
X 1999 3000 World Bank
X 1999 3500 IMF
The question now is how do I merge the two datasets? Since I cannot xtset the latter dataset, the conventional way of merging datasets failed me.
Thanks for your time,
BA
Comment