Thank you. This worked 🙂 Initially I have the data for the same record in 2 separate columns. So I am adding the sequence number first, then use proc sql min case to bring the records from row 1 and row to min(case when Seq = 1 then data end)as data1, min(case when Seq = 2 then data end)as data2 Not sure if there is any easier or quicker way, below is my final output, where the data moved from 2 separate rows into one
... View more