Hello, I'm stuck on the following problem. I have a dataset that looks like this. Type Value animal sheep animal dog animal cow office chair office table building skyscraper building appartment building flat building townhouse I need to concatenate the values per type to 1 single string, seperated by a comma and a space (, ). So then I end up with somethinig like Type NewValue animal sheep, dog, cow office chair, table building skyscraper, appartment, flat, townhouse I can transpose this dataset and then concatenate the values together. But the problem is that the number of values per type can vary up to an unknown number. So on one moment in time there could be 4 maximum values per type. On another moment in time there could be 10 values per type. I figured out I can use ATTRN(NSVARS) to calculate the number of variables/columns that the transpose creates but I can't figure out the syntax mnsto use this number to write it down to something like catx(', ',&Column1 to &Column ) where is the last Column1 is the first column created by the transpose and Column is the last. Does anyone have a solution for this? Many thanks in advance.,
... View more
