Hi Reeza, thank you for the suggestion. I have attempted to use the script as posted: data want; array p{0:3} _temporary_; set have; by object; if first.object then call missing(of p{*}); p{mod(_n_,4)} = price; lowest = min(of p{*}); highest = max(of p{*}); run; In the 3rd line, would I be replacing 'object' with a column in my data set which is numerically ordered such as a date?
... View more