Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down on April 23, and its replacement, **statalist.org** is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
henrik andersson <henrik.andersson@tse-fr.eu> |

To |
"statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu> |

Subject |
RE: st: Selecting specific observations based on two variables |

Date |
Wed, 19 Jun 2013 13:57:32 +0000 |

Thanks Maarten! I works perfectly. Henrik -----Original Message----- From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Maarten Buis Sent: mercredi 19 juin 2013 15:25 To: statalist@hsphsun2.harvard.edu Subject: Re: st: Selecting specific observations based on two variables On Wed, Jun 19, 2013 at 3:15 PM, henrik andersson wrote: > I want to: > > (a) Use only one observation per Id > (b) Use observation which value of Year is closest in absolute terms to 2009 (if Year==2009 then that observation(s) should be chosen). > (c) If tie in (b) use observation with lowest value of Year. > In addition if the above criteria is not able to single out one observation per Id, e.g. if there are two observation in the year 2009, it would be great if Stata then randomly could decide which one to pick. The following example satisfies all criteria: *------------------ begin example ------------------ clear input id year 1 2001 1 2002 1 2005 1 2009 1 2011 2 2001 2 2002 2 2003 2 2004 2 2006 2 2007 2 2011 end gen dist = abs(2009-year) bys id (dist year): gen touse = _n == 1 sort id year lis *------------------- end example ------------------- * (For more on examples I sent to the Statalist see: * http://www.maartenbuis.nl/example_faq ) Hope this helps, Maarten --------------------------------- Maarten L. Buis WZB Reichpietschufer 50 10785 Berlin Germany http://www.maartenbuis.nl --------------------------------- * * 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/

**References**:**st: Selecting specific observations based on two variables***From:*henrik andersson <henrik.andersson@tse-fr.eu>

**Re: st: Selecting specific observations based on two variables***From:*Maarten Buis <maartenlbuis@gmail.com>

- Prev by Date:
**Re: st: Testing interaction terms** - Next by Date:
**Re: st: Testing interaction terms** - Previous by thread:
**Re: st: Selecting specific observations based on two variables** - Index(es):