Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

# Re: st: programming question for instrument scoring with weights

 From Austin Nichols To statalist@hsphsun2.harvard.edu Subject Re: st: programming question for instrument scoring with weights Date Thu, 9 Jun 2011 12:06:32 -0400

```Stas--

Not well, though:

. egen m=rowtotal(rep78 price), missing

. su m rep78 price

Variable |       Obs        Mean    Std. Dev.       Min        Max
-------------+--------------------------------------------------------
m |        74    6168.432    2949.481       3294      15909
rep78 |        69    3.405797    .9899323          1          5
price |        74    6165.257    2949.496       3291      15906

On Thu, Jun 9, 2011 at 12:02 PM, Stas Kolenikov <skolenik@gmail.com> wrote:
> Oops. Thanks, Austin! There's -missing- option of -egen = rowtotal()-
> controlling for the missing value issue, too.
>
> On Thu, Jun 9, 2011 at 10:48 AM, Austin Nichols <austinnichols@gmail.com> wrote:
>> Stas; Marguerite <mbaty1@son.jhmi.edu>:
>> I think the -egen- "function" below is meant to be rowtotal(), not
>> total().  But beware of missing values counting as zeros in such a
>> formulation.
>>
>> On Thu, Jun 9, 2011 at 10:52 AM, Stas Kolenikov <skolenik@gmail.com> wrote:
>> ...
>>> I am assuming that your items are coded 1 for yes, 0 for no. Or you
>>> can do this sequentially:
>>>
>>> egen int total_score = total( item1 item2 [fill in the dots] item19 )
>>> replace total_score = total_score + 4 if item2 == 1
>>> ...
>>> replace total_score = total_score - 3 if item3a == 1
>>>
>>> All of these ways are cumbersome, and the more lines of code you have,
>>> the more likely it is you will have an error somewhere. The choice
>>> between different ways of coding your problem is a matter of
>>> aesthetics, and how readable the code will be to you and other users
>>> of it.

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```