Dear community,

I want to merge panel data for my master thesis, but my knowledge of econometrics is limited and cannot solve this problem. My panel data set are attached. I want to maintain all the data of subsidy.dta and add some additional data from export.dta.

In subsidy.dta, the country's subsidy to the world is annually. In export.dta, the country's export to another country is annually too. So, i hope the final data set is order by:

year country country2 export subsidy subsidy1 subsidy2...
2018 1 1 999 0 0 0
2018 1 2 988 0 0 0
2018 1 0 0 99 99 99
2017 1 1 999 0 0 0
2017 1 2 988 0 0 0
2017 1 0 0 90 99 99

could you please give me some advice? Thank you in advance for your time and help!

Array Array