RE: st: collapse syntax error

["louis boakye-yiadom" <louisby@hotmail.com>]

Ramani,
Your code looks fine to me. How about updating to version 8.2 and trying 
again?

Louis

--------------------


> Hi Statalist members,
> 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);
>
>
> I am using
> Stata/SE 8.0 for Windows
> Born 30 Jan 2003
> Copyright (C) 1985-2003
>
> Can someone please help?
> Thanks in advance,
> Ramani

*
*   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/