collapse (sum) A, by (ID)
replace ID=3 if ID==2
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Amber Katz
Sent: Tuesday, May 09, 2006 1:59 PM
To: statalist
Subject: st: Summing variables over all observations by identifier
Hi,
I'm looking for a function that will sum a variable across all
observations by identifier.
For example, if I have
ID A
1 1
1 0
2 1
2 2
I would like a function that would give me:
SumByID=function(A,ID)
SumbyID would be equal to 1 for all observations with ID=1 and 3 for all
observations with ID=2 .
Thanks very much,
Rachel
*
* 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/
*
* 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/
