Hello, I have a macro variable that stores a comma-separated list of field names, e.g. %let mynumbers = a,b,c; Now I would like to do a search/replace to get a new macro variable like this mynumbers_sum = sum(a),sum(b),sum(c) Here's a two-step solution that seems to work, however it is easy to see why I'm not happy with it: /* step 1: add "sum(" and ")" at both ends and use tranwrd to replace commas by placeholder */ %let mynumbers_1 = sum(%sysfunc(tranwrd(%nrbquote(&mynumbers),%str(,),91sum6))); /* step 2: use translate to replace each character in placeholder */ %let mynumbers_sum = %sysfunc(translate(%str(&mynumbers_1), ")", "9", ",", "1", "(", "6")); Can someone suggest a better/more elegant solution that does not rely on characters I'm not using in my macro variable values? Thanks!
... View more