Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Ian Breunig <ianbreunig@gmail.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | st: Is there a command for picking off the lowest values of an Identified group? |
Date | Thu, 29 Jul 2010 09:43:02 -0600 |
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. I have used - collapse - and an if statement to count children under a specified age before but I can't seem to find a command to do what I want above. Thanks ahead of time if you can help! Ian * * 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/