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

RE: st: addition of variables in Stata 11

From   "Nick Cox" <>
To   <>
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. 


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

> 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:

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