I have id, day, and record variables. I would like to change record's values as below rules using ID and DAY:
1. If record is 10 or higher then do the following:
if the same ID and DAY, if record value with 10 or more as first then use the second where record <10, see ID=4 example
if the same ID and DAY and the as first and last (see ID=1 and DAY=4 and ID=2 and DAY=2) then just remove that row
if last then use one preceding with less than 10, see example ID=4 and DAY=2
if in the middle, then use an average of one good preceding and following, see example ID=1 and DAY=6 and ID=4 and DAY=4.
Thank you.
... View more