Hi all,

so I have k databases (55) called name_country_mole.dta. Each database is an unbalanced panel of molecules observed for a certain number of quarters (the number of quarters and the quarters themselves might vary from a database to another). My objective is to find the matching molecules and quarters (i.e. intersection) across those datasets. When I had only 3 or 4 countries what I did was simply a series reclink of the type:
Code:
reclink Molecule quarter using "france_mole.dta", gen(myscore) idm(id_mas) idu(id_us) minscore(1)
so country1 reclinked with country2 obtaining the data countr1_2.dta. Then country_1_2.dta reclinked with country3 to obtain country_1_2_3.dta and so on. Now that I have 55 databases have to find a smarter way to perform such a task.
Can anyone please help me? I was thinking about something involving tempfiles but I am new to these.

Thank you,

Federico