Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: st: addition of variables in Stata 11


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: addition of variables in Stata 11
Date   Sun, 25 Oct 2009 19:11:13 -0000

As usual, -if- and -in- remain available for restriction of observations. 

Nick 
n.j.cox@durham.ac.uk 

Ekaterina Hertog

Dear Nick, Martin and John,
Thank you very much for the advice! Nick's and Martin's clarifications 
on the impossibility of using the -by option is taken.

Nick Cox wrote:

> Please note: 
>
> 1. This is the same function as -egen, rowtotal()- named in my earlier post. -rsum()- was renamed -rowtotal()- in Stata 9. 
>
> 2. However, -by()- is irrelevant to row-wise operations and is in any case not supported (i.e. illegal) with this function. 

John Ataguba

> I suppose these are variables created in rows.  You can try:
>
> egen newvar = rsum(citotal*)
>
> Note that you can also combine this with the by option if you want to restrict to a certain group or so...

Ekaterina Hertog <ekaterina.hertog@sociology.ox.ac.uk>

> I have a set of variables which denote population by age group in a
> location a given individual lives in my dataset and I want to add them
> up to total population in a location where each individual lives.
> The names of the variables I have look as follows:
> citotal1519 (meaning total population of 15 to 19 year olds in the city)
> citotal2024 (meaning total population of 20 to 24 year olds in the city)
> citotal2529 (meaning total population of 25 to 29 year olds in the city)
> …
> citotal7074 (meaning total population of 70 to 74 year olds in the city)
>
> I was wondering if it might be possible to somehow ask Stata to add all
> the variables which start with citotal?

*
*   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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index