Try
forvalues i = 1/2 {;
local j=`i'+1
gen days`i'`j' = date`j'-date`i';
};
cheers,
Jeph
Hugh Colaco wrote:
> Hi,
>
> I'm trying to get the no of days between dates for several dates. I
> want to create variables days12 and days23 (see example below). I
> tried to run the foll program
>
> forvalues i = 1/2 {;
> gen days`i'`i+1' = date`i+1'-date`i';
> };
>
> but I get days11 and days22 as the new variables and the values are 0.
>
> Thanks,
>
> Hugh
>
>
> date1 date2 date3 days12 days23
> 12/13/1995 5/17/1996 6/14/1996 156 28
> 6/22/1999 7/16/1999 24
> 7/3/1996 9/25/1996 10/11/1996 84 16
> 3/29/1995 6/23/1995 7/12/1995 86 19
> 11/9/1994 5/5/1995 8/17/1995 177 104
> 9/22/1998 11/10/1998 11/24/1998 49 14
> 9/19/1996 3/25/1997 5/27/1997 187 63
> 9/8/1994 10/18/1994 40
> 5/13/1993 7/13/1993 8/6/1993 61 24
> 6/30/1998 7/23/1998 7/29/1998 23 6
> 12/17/1999 1/18/2000 2/7/2000 32 20
>
> *
> * 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/
