Good morning,
I have a data set like this. I want to know mean number of visit per patient. Same Incidentid and different visdate means same patient visiting clinic more than one time on different dates.
How to code for the result i want?
IncidentID VISDATE
1 7/3/2017
2 7/3/2017
3 7/5/2017
4 7/5/2017
5 7/5/2017
6 7/7/2017
6 7/5/2017
7 7/5/2017
8 7/5/2017
8 7/7/2017
9 7/5/2017
10 7/6/2017
11 7/6/2017
12 7/6/2017
12 7/17/2017
13 7/6/2017
14 7/7/2017
15 7/12/2017