Sara,
Use a generate rather than a replace statement in the last line.
gen member=substr(var1,1,6)
gen oldate = substr(var1,10,14)
gen x = substr(var1,29,4)
drop if _n ==1
destring member, replace
destring x, replace
drop if _n == 5
drop var1
gen date=date(oldate,"md20y")
format date %td
gen cumx = sum(x)- x
Cheers,
Robert
Robert A. Yaffee, Ph.D.
Research Professor
Shirley M. Ehrenkranz
School of Social Work
New York University
home address:
Apt 19-W
2100 Linwood Ave.
Fort Lee, NJ
07024-3171
Phone: 201-242-3824
Fax: 201-242-3825
[email protected]
----- Original Message -----
From: sara borelli <[email protected]>
Date: Saturday, May 5, 2007 2:45 pm
Subject: st: cumulate values of X whithin group
To: [email protected]
> Dear Statalist members,
>
> I have the following question:
>
>
> Member Date X
> 133 04-05-2000 1
> 133 04-07-2000 4
> 133 05-06-2000 2
> 133 07-10-2000 3
>
> 145 06-05-2000 5
> 145 06-15-2000 5
> 145 08-05-2000 0
> 145 10-20-2000 2
> 145 11-05-2000 4
> 145 12-03-2000 6
>
> Within each member, I need to create a variable that
> cumulates the values of X up to the date of the
> current observation excluding the value of X of the
> current observation, that is I need to create Xnew
> such that:
>
> Member Date X Xnew
> 133 04-05-2000 1 0
> 133 04-07-2000 4 1
> 133 05-06-2000 2 5
> 133 07-10-2000 3 7
>
> 145 06-05-2000 5 0
> 145 06-15-2000 5 5
> 145 08-05-2000 0 10
> 145 10-20-2000 2 10
> 145 11-05-2000 4 12
> 145 12-03-2000 6 16
>
> any help would be really appreciated
> [email protected]
>
>
>
> ___________________________________
> L'email della prossima generazione? Puoi averla con la nuova Yahoo!
> Mail: http://it.docs.yahoo.com/nowyoucan.html
> *
> * 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/
