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: basic question
From
Phil Clayton <[email protected]>
To
[email protected]
Subject
Re: st: basic question
Date
Tue, 23 Aug 2011 11:19:08 +1000
You can use it, but sal will be missing when any one of v9535, v9102 or v1022 are missing. This is correct when you think about it - how do you the know the sum of some numbers when you don't know what all the numbers are?
If, for your purposes, it's valid to consider missing values to be excluded from the total, you could use the -egen- function rowtotal:
egen sal=rowtotal(v9535 v9102 v1022)
See -help egen-
Phil
On 23/08/2011, at 11:11 AM, Nadine Brooks wrote:
> By there are missing values particularlly in v9102 and v1022, so I
> think that I can not use the operator +, can I?
>
>
>
> 2011/8/22 Daniel Marcelino <[email protected]>:
>> try
>>
>> gen sal= (v9535 + v9102 + v1022)
>>
>> Daniel
>>
>>
>> On Mon, Aug 22, 2011 at 8:54 PM, Nadine Brooks <[email protected]> wrote:
>>> Hi statalist
>>>
>>> I am a beginner Stata user and I am having trouble to generate a new
>>> variable. I am using:
>>> gen sal=sum (v9535,v9102,v1022)
>>> and I am getting: v9535,v9102,v1022 invalid name
>>> r(198);
>>>
>>> But the names of all the variables are correct, so what I am doing wrong?
>>>
>>> Thanks
>>> *
>>> * 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/
>>>
>>
>>
>>
>> --
>> About me: http://danielmarcelino.zip.net/
>>
>> *
>> * 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/