For my research I would like to keep only certain record_ids.
I have multiple measurements per day, which I have to break down to only 1 measurement per day, based on the 'accuracy' of that measurement.
I have created an accuracy variable '..._choice', which gives numbers to whether it is a first choice variable, or a second, third etc.
So how do I select/keep the cases with 1 measurement per day with the highest choice?
Thanks in advance!
I have multiple measurements per day, which I have to break down to only 1 measurement per day, based on the 'accuracy' of that measurement.
I have created an accuracy variable '..._choice', which gives numbers to whether it is a first choice variable, or a second, third etc.
So how do I select/keep the cases with 1 measurement per day with the highest choice?
Thanks in advance!