Good afternoon, I am attempting to create an indexing variable that takes into account two variables (MATCHID and date). Below is an example of the variable "n" that I would like to create. I have tried a number of commands ("by MATCHID date: gen n = _n"; "sort MATCHID date" and then "by MATCHID: gen n = _n"; "egen n=group(MATCHID date)") but none get me to where: (a) the value of "n" is repeated when the date is repeated for a particular MATCHID, and (b) where the counter starts over at 1 for a new MATCHID.
MATCHID n--what I want Date
A1 1 8/18/2017
A1 2 9/9/2017
A1 3 10/14/2017
A1 4 11/23/2018
A1 5 6/5/2019
A1 5 6/5/2019
A1 6 7/4/2019
A10 1 9/9/1999
A10 2 1/14/2001
A10 3 8/8/2004
A10 4 7/17/2007
I appreciate any guidance you can provide.
Thank you,
Jamie