st: collapse?

["dnurhan" <dnurhan@eng.marmara.edu.tr>]

  Dear All:

i am working w/ a data set which looks like:


 HouseHold ID         Member No         Income          Age        EdLevel
  1001                             1                       $20,000 
40             1
  1001                             2                          40,000 
32            3
  1001                             3                             . 
5            .
  1001                             4                             . 
3           .
  1001                             5                           12,000 
68           4
  1002                             1                          45,000 
45            5
  1002                             2                          50,000 
55            5
  1003                             1                          34,000 
39            2
  ..........................................................................................................

i would like to create one record per household where each household's Age 
and EdLevel is the one of its highest
income earner. Namely:

HouseHold ID          Age        EdLevel
  1001                         32               3
  1002                         55               5                  etc..

i do not know how to trick the "collapse by MemberNo" command to do the 
job. Any help would be greatly
appreciated. Thanx in advance.    nurhan

 Nurhan Davutyan
 Industrial Engineering Dept.
 Marmara University
 Goztepe Campus
 34722 Kadikoy/Istanbul
 Turkey
 Phones: +/90/(0)216 349 77 28 home
               +/90/(0)216 330 37 34/213 work
               +/90/(0)555 339 05 31 mobile

 Web Page:
http://posta.marmara.edu.tr/~ndavutyan/fbe/index.htm
http://www.eng.marmara.edu.tr/english/ie/index.html

E-mail:  dnurhan@eng.marmara.edu.tr
            dnurhan@hotmail.com





*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/