Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

# Re: st: Creating a variable from several "subvariables"

 From "M.P.J. van Zaal" To statalist@hsphsun2.harvard.edu Subject Re: st: Creating a variable from several "subvariables" Date Sat, 04 Dec 2010 14:01:43 +0100

```Your method works allright.

But i just figured out a different method

"egen x_total=total(x1), by(x1- x12)"

The methods give slightly different results. Which method would be the
correct approach?

----- Original Message -----
From: Mitch Abdon <mitchaabdon@gmail.com>
Date: Saturday, December 4, 2010 1:55 pm
Subject: Re: st: Creating a variable from several "subvariables"
To: statalist@hsphsun2.harvard.edu

> egen x_total=rsum(x_1-x_12)    //assuming that the variables are
> in order
>
> On Sat, Dec 4, 2010 at 8:43 PM, M.P.J. van Zaal
> <Matthias.vanZaal@student.uva.nl> wrote:
> > Dear Statalist users,
> >
> > For my research I have determined the value of a variable in 12
> > scenarios.
> >
> > "gen x_1= "input function and values" if scenario1==1"
> >
> > Each scenario's values differ in some aspect.
> >
> > I have now 12 variables, x_1 to x_12, each with n=+/- 500.
> >
> > For the next step I would like to create a new variable which
> > incorporates x_1 - x-12.
> > The variable would be something like "x_total= x_1+x_2+....+x_12",
> > with n=+/-6000.
> >
> > I tried to simply add them with the use of the generate command but
> > this did not work. I also tried to use egen with the sum
> command, but
> > this also did not work.
> >
> > What would be the correct way to create "x_total" in STATA?
> >
> > Many thanks!
> >
> > Mathijs
> > *
> > *   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/
> >
>
>
>
> --
> Best,
> Mitch
>
>
> Arnelyn Abdon
> +639178034402
>
> *
> *   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/
```