if i understand correctly, you can sort by time, then use a first. function to create a count, then you have 1,2,3,4. by string function here you go, time1 time2 time3 time4...etc http://www.ats.ucla.edu/stat/sas/faq/enumerate.htm
... View more
I actually agree with mr. boostrap. you can basically use proc transpose, but you need a unique key say "Account" to eventually merge all columns. Change in new variable names can be achieved by a macro fairly easily.
... View more