# st: Re: replacing values in a variable with rowsums, aka "ereplace"

 From "Kim Lyngby Mikkelsen (KLM)" To Subject st: Re: replacing values in a variable with rowsums, aka "ereplace" Date Tue, 15 Jul 2008 09:43:12 +0200

```If you have consecutive values, you should try to use -forvalue-, otherwise you could try to use -foreach-.

If you have y=1, y=2, ..., y=n, you could try to do something like this

forvalue n = 1/n {
egen x_`n'=rowtotal (d1-d40) if y=`n'
}
gen x=.
forvalue n = 1/n {
replace x=x_`n' if y=`n'
drop x_`n'
}

Rrgards Kim

-----Oprindelig meddelelse-----
Fra: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] På vegne af oreuter@emory.edu
Sendt: 14. juli 2008 16:17
Til: statalist@hsphsun2.harvard.edu
Emne: st: replacing values in a variable with rowsums, aka "ereplace"

Dear Statlisters,

I am searching for something that would do the equivalent of an
'ereplace'.  I have a set variables for which I generated a -rowtotal-
given some condition, e.g. (egen x=rowtotal (d1-d40) if y=1), but then
I need to replace some values in that same variable (x) with a
different -rowtotal- given a different condition.  I dont know how else
to explain it except to say that if there were an  'ereplace' command
the next command would look like this:

"ereplace" x=rowtotal(d2-d40) if y=2

In other words, I need to replace values in x with different sums of
variables.  I need to do this for a great many conditions so typing out
the list of variables to be added for each condition would be a minor
pain.

Ora John Reuter
Emory University
Department of Political Science
327 Tarbutton Hall
1555 Dickey Drive
Atlanta, GA 30322
Phone(Atlanta)-1-931-312-9132
&#1058;&#1077;&#1083;&#1077;&#1092;&#1086;&#1085;
(&#1055;&#1077;&#1088;&#1084;&#1100;)-+89197154869

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

Privileged, confidential or patient identifiable information may be contained in this message. This information is meant only for the use of the intended recipients. If you are not the intended recipient, or if the message has been addressed to you in error, do not read, disclose, reproduce, distribute, disseminate or otherwise use this transmission. Instead, please notify the sender by reply e-mail, and then destroy all copies of the message and any attachments.

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```