Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.

Re: st: Weights now allowed

 From Daniel Almar de Sneijder To statalist@hsphsun2.harvard.edu Subject Re: st: Weights now allowed Date Thu, 13 Sep 2012 14:24:43 -0400

```wow its a miracle, it actually works

thanx

i'll still go for tiger :)

On Thu, Sep 13, 2012 at 2:16 PM, Scholes, Shaun <s.scholes@ucl.ac.uk> wrote:
> Are you sure? Try:
>
> clear
> input x1 x2 x3
> . 1 2
> 2 2 3
> 4 . .
> end
>
> egen tiger = rowmean(x1-x3)
> list tiger
>
> Sorry, I am a golf fan. Maybe that should be -egen Rory-.
> best wishes
> Shaun
>
>
>
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Daniel Almar de Sneijder
> Sent: 13 September 2012 19:05
> To: statalist@hsphsun2.harvard.edu
> Subject: Re: st: Weights now allowed
>
> Hello and thanks for the message.
>
> The reason I loop over the data is because sometimes only 3 variables have an observation.
> When I use rowmean then it treats the outcome as 0 if at that row not all observations have a value. So to clarify, I want to obtain the average in this way:
>
> x1 x2 x3     avg(x1 x2 x3)
> .   1   2             1.5
> 2  2   3              7/3
> 4 . .                   4
>
>
>
>
>
>
> I tried it btw now with 'i' but it still doesnt work???
>
>
> ***** calculates average expretage
> drop ravgexpretage
> gen double ravgexpretage = r1expretage
> forvalues i = 1/30659 {
> replace ravgexpretage[`i'] = (r1expretage[`i'] + r3expretage[`i'] + r4expretage[`i'] + r5expretage[`i'] + r6expretage[`i'] + r7expretage[`i'] + r8expretage[`i'])/7 }
> ******
>
>
>
>
> On Thu, Sep 13, 2012 at 1:50 PM, Joerg Luedicke <joerg.luedicke@gmail.com> wrote:
>> You would need to type [`i'] instead of [i] since i is a local macro
>> here (see -help macro- and -help forvalues-). However, there is no
>> need to loop over all observations in your data, see -help egen
>> rowmean-.
>>
>> J.
>>
>> On Thu, Sep 13, 2012 at 12:23 PM, Daniel Almar de Sneijder
>> <dasneijder@gmail.com> wrote:
>>> Hello Stata
>>>
>>> When I attempt to run:
>>>
>>> ***** calculates average exp ret age
>>> drop ravgexpretage
>>>
>>> gen double ravgexpretage = r1expretage
>>>
>>> forvalues i = 1/30659 {
>>>   replace ravgexpretage[i] = ( r1expretage[i] + r3expretage[i] +
>>> r4expretage[i] + r5expretage[i] + r6expretage[i] + r7expretage[i] +
>>> r8expretage[i] )
>>>   replace ravgexpretage[i] =  ravgexpretage[i] *(1/7) }
>>>
>>> I receive the message: "weights not allowed"
>>>
>>> What is the problem and How can I circumvene this?
>>> My initial idea was to add all the variables up and then divide it by
>>> 7, which works. However it only adds the observations up if each
>>> variable has a observation So that is why I decided to do it like
>>> this.
>>>
>>> Thanks,
>>> Daniel
>>> *
>>> *   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/
>> *
>> *   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/
> *
> *   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/
>
>
> *
> *   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/
*
*   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/
```