Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | Nick Cox <n.j.cox@durham.ac.uk> |
| To | "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu> |
| Subject | st: RE: Difference of values in the same column/variable |
| Date | Tue, 15 Nov 2011 09:57:38 +0000 |
In your example bysort time (group) : gen newvar = ewportnet - ewportnet[_n-1] Nick n.j.cox@durham.ac.uk yilmag@rpi.edu 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 * * 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/