Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | Andreas Dimopoulos <ad382@sussex.ac.uk> |
| To | <statalist@hsphsun2.harvard.edu> |
| Subject | Re: st: merge bilateral panel data |
| Date | Thu, 03 Apr 2014 22:23:40 +0100 |
That seems to be working! Many thanks, Andreas On Thu, 3 Apr 2014 16:56:41 -0400, Alfonso Sánchez-Peñalver <alfonso.statalist@gmail.com> wrote: > On your first dataset, does the reporter/year pair provide a unique > observation? Also, what version of Stata are you using, because if its > prior to 11 the syntax is different. Ill assume that you are using Stata 11 > or later, and that the reporter/year pair provides a unique observation in > the first dataset. > > First have both datasets sorted by reporter year (sort reporter year). Let > us call dataset 1 ds1, and dataset 2 ds2. Have ds1 in memory, i.e. open in > Stata. The command you want is > > merge 1:m reporter year using ds2 > > Let me know if that works. Best, > > Alfonso Sánchez-Peñalver, PhD > > Visiting Assistant Professor > Suffolk University > Senior Instructor > UMass Boston > > > > On Apr 3, 2014, at 4:35 PM, Andreas Dimopoulos <ad382@sussex.ac.uk> wrote: > >> hello, >> >> I am trying to merge two panel datasets where the one has each country >> for >> different number of years and the relevant characteristics and another >> dataset with pair of countries and their in-between trade. For example, >> >> Dataset 1: >> >> reporter year var1 >> Alb 2000 x1 >> Alb 2002 x2 >> . . . >> . . . >> . . . >> Can 2000 X67 >> Can 2003 X68 >> >> My second dataset has again panel data but with pairs of countries >> >> reporter partner year trade >> >> alb arg 2003 k >> alb aus 2000 k1 >> alb aus 2002 k2 >> . . . . >> . . . . >> . . . . >> can ken 2000 m >> can ken 2004 m2 >> >> I tried to merge the data after I had used the command "sort". However, >> stata said that reporter cannot uniquely identify observations which I >> understand since I have the pairs of countries two, three,four times >> etc. >> depending on the years...Any ideas of how to merge? >> >> Thanks a lot, >> A >> * >> * For searches and help try: >> * http://www.stata.com/help.cgi?search >> * http://www.stata.com/support/faqs/resources/statalist-faq/ >> * http://www.ats.ucla.edu/stat/stata/ > > > * > * For searches and help try: > * http://www.stata.com/help.cgi?search > * http://www.stata.com/support/faqs/resources/statalist-faq/ > * http://www.ats.ucla.edu/stat/stata/ * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/