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)
Can anyone please help me? I was thinking about something involving tempfiles but I am new to these.
Thank you,
Federico
0 Response to Intersection among datasets
Post a Comment