Dear Alvine,
Please take a look at what follows:
------------------begin example-----------------------
g  begin_2 = date( begin,"dm20y")
format  begin_2%d
g   end_2 = date(  end,"dm20y")
format   end_2%d
g time= end_2- begin_2
g time_0=time if treat==0
g time_1=time if treat==1
-------------------end example------------------------
HTH and Kind Regards,
Carlo
[email protected] wrote:
Dear all,
My data deals with subjects who receive 1, 2 or more treatements over time.
We want to know how many time they spent with 1 treatment, 2 treatments, 3
treatments , ...
Data are as follows:
id	   begin	      end	   treat
1	04 Apr 2006	  06 Apr 2006	1
1	05 Apr 2006	  09 Apr 2006	0
1	08 Apr 2006	  12 Apr 2006	1
2	15 May 2006	  16 May 2006	1
2	16 May 2006	  24 May 2006	1
2	16 May 2006	  17 May 2006	1 
How can I calculate time spent with 1 treat for id=1, time spent with 2
treat
for id=1, ...
Maybe with after data has been stset ? 
Thank you for help !
Alvine Bissery
*
*   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/