Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: Weights now allowed
From
Daniel Almar de Sneijder <[email protected]>
To
[email protected]
Subject
Re: st: Weights now allowed
Date
Thu, 13 Sep 2012 14:04:41 -0400
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
<[email protected]> 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
> <[email protected]> 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/