Hi everyone! I have quite a bit of data (varying amounts per day) and I only want one data point (highest) per day. Sometimes, there's no data for that date. Have: (note, I'm only showing one participant, UU0500, but there will be many) UUID injury_date date_collected heart_rate UU0500 10/01/20 10/01/20 100 UU0500 10/01/20 10/01/20 104 UU0500 10/01/20 10/02/20 98 UU0500 10/01/20 10/02/20 99 UU0500 10/01/20 10/02/20 110 UU0500 10/01/20 10/04/20 89 UU0500 10/01/20 10/04/20 105 UU0500 10/01/20 10/04/20 103 UU0500 10/01/20 10/04/20 100 Want: I want the highest value per date, for the same UUID. The caveat is, I need all the dates to be a function of "days from injury_date". I don't care about the date itself. UUID heart_rate_d0 heart_rate_d1 heart_rate_d2 heart_rate_d3 UU0500 104 110 . 105 What I'm thinking is there needs to be a new variable created that counts the number of days between the date of injury and the date of the data collected. Then there needs to be some serious data manipulation... I have no formal training with this and would really appreciate any of your help!
... View more