I am trying to calculate min and max in multiple instances for my data.
Here is an example of my data set.
person_id event id var2 var3 var4 var5 var6
1 1 2 3 1 3 5
1 2 6 1 2 4 1
2 3 3 1 4 2 5
So there are people with multiple rows in my data however each event_id will be unique.
I am trying to calculate an overall min and max for each person and an individual min and max for each event.
Here is what I am looking for:
person_id event id var2 var3 var4 var5 var6 maxALL minALL maxONE minONE
1 1 2 3 1 3 5 6 1 5 1
1 2 6 3 2 4 3 6 1 6 2
2 3 3 2 4 2 5 5 2 5 2
Thank you in advance!