my data appears like this:
ID
A1
A2
A3
A4
A5
A6
A7
A8
A9
A10
1
B1
B2
2
B1
3
4
B1
B2
B3
B4
B5
B6
5
B1
6
7
8
B1
B2
B3
B4
B5
B6
B7
B8
B9
9
10
and what I would like is to combine this data into a single data field (i.e. B1,B2,B3) with commas separating the data. If I use something like this:
newvar = catx(',', A1, A2, A3........A10);
I get a period at the end of the field - so the Newvar could look like: B1,B2,.
Also my fields could range from A1 to A100 depending on the output. Is there a simple way for me to make this field dynamic with the data?
... View more