st: Re: Data management

["Michael Blasnik" <michael.blasnik@verizon.net>]

No programming needed:

egen sumvar=sum(var)
gen newvar=var/(sumvar-var)

If you have groups over which you need to calculate the sum, then you can 
use the -by- prefix to the egen sumvar command.

Michael Blasnik


----- Original Message ----- 
From: "Roy,Suryadipta" <suryadipta.roy@lawrence.edu>
To: <statalist@hsphsun2.harvard.edu>
Sent: Tuesday, February 13, 2007 6:43 PM
Subject: st: Data management



> Hi,
>
> I am trying to generate a new variable for the following form of data:
> id      var
> 1 A
> 2 B
> 3 C
> 4 D
> 5 E
>        =sum(A+B+C+D+E)
>
> I am trying to generate a third column where the 1st observation= 
> A/(B+C+D+E); 2nd observation= B/(A+C+D+E), and so for all the five 
> observations. Any help will be highly appreciated. I am wondering if I 
> need to do some programming in such cases; so any guidance in this 
> direction (so that I might be more self-sufficient henceforth) will be 
> very helpful.
*
*   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/