Dear Statalist,
I have a data sample like this:
| Username | Event time | How many events happened within a month after first one | 
| A | 2019-05-03 | 2 | 
| A | 2019-05-13 |  | 
| A | 2019-05-29 |  | 
| A | 2019-09-27 |  | 
| B | 2020-10-01 | 1 | 
| B | 2020-10-18 |  | 
| B | 2020-11-9 |  | 
|  |  |  | 
 
I would like to calculate how many events of one user happened within a month 
after his/her first event. For example, in this sample, for user A, the number of events that happened after 2019-05-03 is 3, but within a month, is 2. I do not know how to calculate the number 3, since my dataset is very large.
Could you give me some advice?
Thanks a lot!
Best,
Iris Ru
0 Response to Calculate the difference between dates of events and filter if the events happned within a month
Post a Comment