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

# Re: st: cum sum in new varaible

 From Richard Goldstein To statalist@hsphsun2.harvard.edu Subject Re: st: cum sum in new varaible Date Fri, 15 Apr 2011 08:24:53 -0400

```1. use the -egen- command with the the total function

2. see -help format-

Rich

On 4/15/11 3:30 AM, Max Fotbollen wrote:
>
> Hi
> I need to have cumulative sum of one certain real number variable set into a new variable. Also I need to be able to list the value of variable in a way one can see all degits.
>
> Es:
> This my original variable
> . list rrs in 1/16
>      +-------+
>      |   rrs |
>      |-------|
>   1. |    -1 |
>   2. |     0 |
>   3. |    -1 |
>   4. |     0 |
>   5. |     0 |
>      |-------|
>   6. |  -105 |
>   7. |    -5 |
>   8. |    38 |
>   9. |     1 |
>  10. |     0 |
>      |-------|
>  11. |     0 |
>  12. |  -502 |
>  13. |   -33 |
>  14. |     6 |
>  15. |  -146 |
>      |-------|
>  16. | -5068 |
>      +-------+
> Actuallu what i need is the cumulative sum of this variable set into one variable. I do not how to do it.(this is my first question).
> So what I do is to sum(rrs). This is the result i get
>
>      +----------+
>      |----------|
>   1. |        1 |
>   2. |        1 |
>   3. |        2 |
>   4. |        2 |
>   5. |        2 |
>      |----------|
>   6. |    11027 |
>   7. |    11052 |
>   8. |    12496 |
>   9. |    12497 |
>  10. |    12497 |
>      |----------|
>  11. |    12497 |
>  12. |   264501 |
>  13. |   265590 |
>  14. |   265626 |
>  15. |   286942 |
>      |----------|
>  16. | 2.60e+07 |
>
> The second question is that i want to see the value of the last obeservation in the same format as in the previous observation.
>
> Thanks for comments and suggestion,
>
> Max
> P.S. I read about cumsum, but i think it is only for ones and zeros
*
*   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/
```