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 |
Ian Breunig <ianbreunig@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: Is there a command for picking off the lowest values of an Identified group? |

Date |
Thu, 29 Jul 2010 09:52:34 -0600 |

Thanks a lot Neil! You saved me some time this morning. Ian On Thu, Jul 29, 2010 at 9:49 AM, Neil Shephard <nshephard@gmail.com> wrote: > On Thu, Jul 29, 2010 at 3:43 PM, Ian Breunig <ianbreunig@gmail.com> wrote: >> I want to find the age of the mother's youngest child. >> >> If, for example, I have data as follows: >> >> Mother ID: Child ID: Child Age: >> >> 1 a 1 >> 1 b 2 >> 1 c 3 >> 1 d 4 >> 2 e 10 >> 2 f 10 >> 2 g 12 >> 3 h 5 >> 3 i 7 >> >> Is there a simple command to tell me the youngest age for every Mother >> ID or do I have to use a do loop and if statement to do this? If so >> can anyone help me out with the most efficient way to code the do >> loop. > > No loop required, the following should do what you are after (note > I've assumed variable names, as the above are illegal in Stata as > spaces in variable names are not permitted) > > bysort mother_id (child_age) : gen youngest_child = child_age[1] > > The variable youngest_child will be constant within each grouping of > mother_id and will contain the age of the youngest child (by virtue of > having sorted the data on that variable). > > Neil > > -- > "... no scientific worker has a fixed level of significance at which > from year to year, and in all circumstances, he rejects hypotheses; he > rather gives his mind to each particular case in the light of his > evidence and his ideas." - Sir Ronald A. Fisher (1956) > > Email - nshephard@gmail.com > Website - http://slack.ser.man.ac.uk/ > Photos - http://www.flickr.com/photos/slackline/ > > * > * For searches and help try: > * http://www.stata.com/help.cgi?search > * http://www.stata.com/support/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/statalist/faq * http://www.ats.ucla.edu/stat/stata/

**References**:**st: Is there a command for picking off the lowest values of an Identified group?***From:*Ian Breunig <ianbreunig@gmail.com>

**Re: st: Is there a command for picking off the lowest values of an Identified group?***From:*Neil Shephard <nshephard@gmail.com>

- Prev by Date:
**Re: st: Is there a command for picking off the lowest values of an Identified group?** - Next by Date:
**st: how to use for* loops "noisily"?** - Previous by thread:
**Re: st: Is there a command for picking off the lowest values of an Identified group?** - Next by thread:
**st: AW: Is there a command for picking off the lowest values of an Identified group?** - Index(es):