Prev: datepart function
Next: Zero inflated gamma distribution
From: evallyne sikuku on 7 Sep 2009 10:13
Hi all=2C

I need some help

How can I automatically generate a count for the visits of patients coming =
to the clinic where every visit per patient will have visit number.

If my data looks like this=3B

current data







pid
date

1
1/1/2009

1
2/1/2009

1
4/2/2009

1
28/3/2009

2
4/6/2008

2
3/1/2009

2
4/2/2009

3
14/1/2009

3
20/3/2009

=20

and I want the new data to have the visit_count as follow







pid
date
visit_count

1
1/1/2009
1

1
2/1/2009
2

1
4/2/2009
3

1
28/3/2009
4

2
4/6/2008
1

2
3/1/2009
2

2
4/2/2009
3

3
14/1/2009
1

3
20/3/2009
2

=20

Thanks guys

Eva

=20

=20

=20

_________________________________________________________________
With Windows Live=2C you can organize=2C edit=2C and share your photos.
http://www.microsoft.com/middleeast/windows/windowslive/products/photo-gall=
ery-edit.aspx=
 | 
Pages: 1
Prev: datepart function
Next: Zero inflated gamma distribution