Ramani,
You don't have to -collapse- your data to calculate the household
size.
. egen hhsize = sum(num), by(uhhid)
Friedrich Huebler
--- Ramani Gunatilaka <[email protected]> wrote:
> I am trying to calculate household size using collapse. The dataset
> has two variables, a unique household ID <uhhid> and the serial
> numbers of the household members <hhmem>.
> This is the code I used and the error I get.
>
> . /*create variable household size*/
> . use rindvar02, clear
>
> . keep uhhid hhmem
>
> . sort uhhid hhmem
>
> . gen num=1
>
> . collapse (sum) hhsize=num, by(uhhid)
> invalid syntax
> r(198);
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.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/
