Hi everyone, I'm new to SAS and I would like some help. I have multiple observations at every timestamp and I want to keep the median value for every timestamp. For example: what i have is: date             time            value 20010101   16:33:35      1 20010101   16:33:35      3 20010101   16:33:35      3 20010101   16:33:35      6 20010101   16:33:38      1 20010101   16:33:38      2 20010101   16:33:38      6 what i want is: date            time            value 20010101   16:33:35      3 20010101   16:33:38      2 What i have found so far is to keep the first or the last observation by using: *# keep last recorded value; data hello; set hello2 (keep=date time value); by date time;    if last.time; format time time.; run; my question is is it possible to find the median and put it at the begin or the end for every timestamp , and then apply it with my code? Or do you have a better solution Many thanks in advance! ... View more