I think you can do that with the TABULATE stage that is on the IBM Downlo ads website. I think after you sort by column 1.2 then you can do a TABULATE BY 1-2 LIST and it will use columns 1-2 as a key and join the rest together as one record per key. /Tom Kern
On Thu, 10 Jul 2008 10:57:49 -0500, Huegel, Thomas <[EMAIL PROTECTED]> wr ote: >This shouldn't be very hard, but I seem to be a little slow today.. can' t find my Geritol. > >I can do this with a bunch of 'IF''s and 'DO's but I was looking for something prettier. >REXX or a PIPE, it doesn't matter. >I have input that looks like this: > >01 data-a >01 data-b >01 data-c >01 data-d >02 data-a >02 data-b >02 data-c >02 data-d >. >. >99 data-x >. >xx data-a is always unique. > >I want to create a variable that looks something like this: >X.01 data-a data-b data-c data-d >X.02 data-a data-b data-c data-c > >or since data-a is unique I could name the variable data-a and have data -b data-c data-d in the var... then I'd have to keep track of all of the nam es (data-a). > >Anyone see a super simple way to do this with pretty code? > > > >