All one step:
. collapse (max) X1, by(UIDhhstr)
-----Original Message-----
From: F V [mailto:[email protected]]
Sent: Thursday, October 06, 2005 1:59 PM
To: [email protected]
Subject: st: question for hierarchical (i.e. hh & person) file
I have a very large data-set (i.e. around 60,000
households, and around 320,000 individuals). say that
i have three variables: a hh identifier, a person
identifier, and an X1 variable of interest that
measures whether a person is X1 or not.
UIDhhstr X1 UIDpersonstr
01101021 1 0110102101
01101021 0 0110102102
01101021 0 0110102103
say I wanted to tell Stata: gen a variable X2 such
that it takes the value of 1 if for any member of a
household X1==1. how can i do this in stata? after
generating X2, then i could collapse the data down to
the household level.
*
* 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/
