Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down at the end of May, and its replacement, **statalist.org** is already up and running.

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

From |
Anna Reimondos <areimondos@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: Difference of values in the same column/variable |

Date |
Thu, 24 Nov 2011 13:23:36 +1100 |

Hi Gokhan Maybe something like gen newvar=. gsort time -group bysort time: replace newvar=ewportret-ewportret[_n+1] if group==1 & group[_n+1]==0 Or in a loop gen newvar=. forvalues n=1/6 { replace newvar=ewportret-ewportret[`n'] if time==time[`n'] & group==1 } Anna On Tue, Nov 15, 2011 at 1:21 PM, <yilmag@rpi.edu> wrote: > Dear All, > > How can i create a new variable that is equal to the difference in ewportret > (see below table) between two groups in the same month? > For example: the first row of the newvar below would be equal to (.0375245- > .041679) and the second row would be equal to(.0397919- .0449738) > > > group time ewportret newvar > > 1 2007m4 .0375245 > 1 2007m5 .0397919 > 1 2007m6 -.0188678 > 0 2007m4 .041679 > 0 2007m5 .0449738 > 0 2007m6 -.0240277 > > > Thank you > > Gokhan > > > * > * 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/

**Follow-Ups**:**Re: st: Difference of values in the same column/variable***From:*Tirthankar Chakravarty <tirthankar.chakravarty@gmail.com>

**References**:**st: Difference of values in the same column/variable***From:*yilmag@rpi.edu

- Prev by Date:
**Re: st: How do I split my string variable by capital letters?** - Next by Date:
**Re: st: Estimation selection model with selmlog/svyselmlog using sample weights** - Previous by thread:
**st: RE: RE: Difference of values in the same column/variable** - Next by thread:
**Re: st: Difference of values in the same column/variable** - Index(es):