Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: RE: Summing variables over all observations by identifier


From   "Amber Katz" <academicgirl@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: Summing variables over all observations by identifier
Date   Tue, 9 May 2006 14:11:55 -0400

Right, but I would like to add this new variable with to rest of the
dataset, rather than creating a new one.  I realize I can collapse and
then merge, but is there a way to do it in one step?

On 5/9/06, Martin, Aurelie <AMartin@imf.org> wrote:
collapse (sum) A, by (ID)
replace  ID=3 if ID==2



-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] 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/

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