 |
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: collapse?
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: [email protected]
[email protected]
*
* 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/