[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: RE: sum and product
> I need to make some calculations that are common for me,
> but utilizing Excel.
> I have two variables (each with 300,000 observations):
> Number of discharges
> and Relative Weight. I need to make this.
> 1. Multiply the number of discharges by the relative weight
> 2. Sum all these results obtained in 1.
> 3. Divide an amount of expenditures between this sum
> results (obtained in
> 2), so I can estimate the value of each of the relative points.
> I never have been used Stata to perform arithmetic
> operations, so excuse me
> if I look so dumb.
-egen- includes a -pc()- function which
takes an expression and which can optionally yield
. egen prop = pc(weight * whatever), prop
yields a variable prop which sums to 1.
Otherwise, see help on -operators-,
help on -functions- and help on -egen-.
* For searches and help try: