Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | Nick Cox <njcoxstata@gmail.com> |
| To | "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu> |
| Subject | Re: st: creation of a new variable using a variable condition |
| Date | Fri, 21 Feb 2014 15:13:49 +0000 |
One way to approach this is bysort id (year): gen newvar = sum(event) >= 1 See also http://www.stata.com/support/faqs/data-management/first-and-last-occurrences/ Nick njcoxstata@gmail.com On 21 February 2014 15:04, Riccardo Valboni <rvalboni@rsm.nl> wrote: > Dear statalist, > > I am trying to do something that it's probably basic but I cannot get to the bottom of it. > I have a typical unbalanced panel dataset. Some of my observations happen to have an event at a certain point in time (coded 1 in the 'event' column). For them I would like to generate a new variable (newvar) that takes value 1 from the year of the first event onwards. The year of the first event obviously changes from case to case. (see the example below) > > id year event newvar > a 2001 0 0 > a 2002 0 0 > a 2003 1 1 > a 2004 1 1 > b 2005 0 0 > b 2006 1 1 > b 2007 0 1 > b 2008 0 1 > b 2009 0 1 > ... > > I imagine that the command to do this starts with: by id... but I wouldn't know how continue that. Any suggestions? > > Thank you! > Riccardo > > > > > Disclaimer > ________________________________ > De informatie verzonden in dit e-mail bericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde van dit bericht. Lees verder: www.eur.nl/email-disclaimer <http://www.eur.nl/email-disclaimer> > The information in this e-mail message is confidential and may be legally privileged. Read more: www.eur.nl/english/email-disclaimer<http://www.eur.nl/english/email-disclaimer> > ________________________________ > > > * > * 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/