Yes, so I actually have up to 10 different times (with associated rate) for each day. I need to extract the AM time for the maximium rate and the PM time for the maximum rate. Originally I used proc rank to rank the rates so that I had a sorted (descending order) list of rates with another column of associated times. With the transpose function, I could then generate columns that had the times of the maximum rates (Rate1 column was a list of times with all maximum movement rate, Rate2 column was a list of times with the second highest movement rate, etc...) for each day. The problem is that the columns (Rate1, Rate2...) are a mix of AM and PM times and I need them seperated out. I tried starting from the beginning again, but I am unable to figure out how to transpose and seperate AM and PM at the same time.
... View more
