Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: collapse?


From   "dnurhan" <dnurhan@eng.marmara.edu.tr>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: collapse?
Date   Sun, 29 Jul 2007 10:44:38 +0300

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/




© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index