Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Eric Booth <ebooth@ppri.tamu.edu> |
To | "<statalist@hsphsun2.harvard.edu>" <statalist@hsphsun2.harvard.edu> |
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 <dmsilv@gmail.com>: >> try >> >> gen sal= (v9535 + v9102 + v1022) >> >> Daniel >> >> >> On Mon, Aug 22, 2011 at 8:54 PM, Nadine Brooks <nb.statalist@gmail.com> 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/