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
Eric Booth <[email protected]>
To
"<[email protected]>" <[email protected]>
Subject
Re: st: basic question
Date
Tue, 23 Aug 2011 01:24:30 +0000
<>
Take a look at -help sum()- to see that the sum function creates a running sum of a single variable(down the column), e.g.,
****
clear
input v9535 v9102 v1022
3 4 5
5 . 6
9 . .
. . .
1 1 1
end
gen sal=sum(v9535)
****
//If you want the row sum/total you can:
**
gen sal2 = v9535+v9102+v1022
**
//but as you note, this creates a missing sum where there are missing values, so one option is to use the -egen- rowtotal:
**
egen sal3 = rowtotal(v9535 v9102 v1022)
**
- Eric
On Aug 22, 2011, at 8:11 PM, 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/