Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: collapse syntax error


From   Ramani Gunatilaka <Ramani.Gunatilaka@BusEco.monash.edu.au>
To   statalist@hsphsun2.harvard.edu
Subject   st: collapse syntax error
Date   Thu, 22 Sep 2005 09:13:43 +0000

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/



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