I am using the below code but i am getting diffrent results in enterprise guide and DI studio. In DI studio i do not see the comma seperated values i only see the value ann no commas but in EG i see the comma seperated value as expected. Any ideas why? array t(50) _temporary_;   do until (last.key);     set bmv_sorted;        by key;        t(position)=value;   end;   bespoke_string=compress(catx(',',of t(*)),".","");   call missing(of t(*)); ... View more

Hi, It is the 8th value as the the first position is the position before the first comma position1,position2,etc ... View more

Hi, After more testing with the code this morning i am getting values put in wrong position if we have multiple value in the string. For example If i use the following code options missing=,; data have; input KEY$  VALUE POSITION; cards; 1     3     5 2     33    9 2     55    3 1     76    1 1     77    2 2     44    29 3     21    2 2     44    29 2     66    26 ; proc sort data=have; by key; run; data want; array t(30) _temporary_;   do until (last.key);     set have;        by key;        t(position)=value;   end;   comma=cats(of t(*));   call missing(of t(*));   put comma=; run; I get the following values 7677,,3,,,,,,,,,,,,,,,,,,,,,,,,, ,,55,,,,,33,,,,,,,,,,,,,,,,66,,44, ,21,,,,,,,,,,,,,,,,,,,,,,,,,,,, As you can see value 33 is shifted to position 8 when it should be position 9. Any ideas why? I cant figure it out. Thanks in advance ... View more

Great thanks for all comments. I have a good idea of how to implment it now with a few minor tweeks. Great starting point to learn about arrays and hashing. ... View more

No positions greater than 30. I have validation on the job that builds the table not to allow this ... View more

Hi, What i mean is so after the last position an extra x amount of commas should be inserted until the total number of commas reaches thirty. So for example, 1,,,,2 would become 1,,,,2,,,,,,,,,,,,,,,,,,,,,, ... View more

Great thanks that works...how i would i limit the padding of the extra commas? Business requiement is a little learninig ... View more

Hi, Many thanks for this...this is the result i am getting 76,.,.,.,3,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,. .,.,55,.,.,.,.,.,33,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,44 .,21,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,. How can i stop the dots inbetweeen the commas? Also need to limit it to 30 commas. Thanks in advance ... View more

Corrected and added another exmple. Applogies and thanks for your response ... View more