Hi there! I'm having a problem with concatenating a series of rows into a single row based on a group within a SAS dataset. Basically a simplified version of what I want is to be able to is start with something like this: data inTable; input letter $ number $; datalines; a 1 a 2 a 3 b 4 b 5 b 6 c 7 d 8 e 9 e 10 f 11 ; run; and end up with something like this: Letter Numbers a 1,2,3 b 4,5,6 c d 7,8 e 9, 10 f 11 The delimeter doesn't matter as long as I can see all the numbers that pertain to a group. In this case I don't know how many 'numbers' would be applied to each letter (assume max 5) and I'd have 100K+ 'letters'. Thanks in advance for your help!!
... View more