Hi, all! I was hoping you could help me out on this query. I am able to do this in Excel using a combination of median and if function (somehow mimicking the averageif built-in function) but would like to have it translated in SAS due to the big amount of data I am working on. For illustration purposes, I have this sample dataset. Month Day Volume 1 1 20 1 2 X 2 1 28 2 2 29 3 1 30 3 2 27 1 1 40 1 2 56 2 1 28 2 2 30 1 1 Y 1 2 30 In the dataset there are missing values represented by X and Y here. I need to fill out these missing values by getting the median of all the same month and same day as that of the missing field. For example, in order to get X, i get the median of all those with month = 1 and day = 2. Similarly for Y, i get the median of all those with month = 1 and day= 1. Appreciate your help! Thank you!
... View more