Hi Experts, Been trying to transpose (but by using arrays) my dataset below; acct date seq paid cost 123 Jan-10 0 0 0 123 Feb-10 0 0 0 123 Mar-10 1 0 0 123 Apr-10 1 100 10 123 May-10 1 150 20 to the dataset below; acct date paid_Jan2010 paid_Feb2010 paid_Mar2010 paid_Apr2010 paid_May2010 cost_Jan2010 cost_Feb2010 cost_Mar2010 cost_Apr2010 cost_May2010 123 Mar-10 0 0 0 100 150 0 0 0 10 20 whereby only the row where the seq becomes 1 the first time is taken in the resulting dataset but with all the paid and cost values in it as well. Is this achievable? Understand that using proc transpose might not work and have been playing around by using arrays but have been unsuccessful so far. Any advise or help is much appreciated! Thank you! 🙂
... View more