Macro variable string into several parts divided by commas and quotes.

[allen_AL]

Thank you very much for your quick response.

[Tom]

It sounds like want to convert a space delimited list of tokens to a quoted list. 

First make sure you have just one space between "words". Then wrap in quotes and replace the internal spaces with quoted spaces.

%let list=a b 
c d e
f

g

;
%let list=%sysfunc(compbl(&list));
%let qlist="%sysfunc(tranwrd(&list,%str( )," "))";

Not sure why you want to add commas also, since SAS does not require them.  Put you could use "," instead of " " and then you would have commas between the quoted strings.

If you are really copying from WORD make sure that what you copy doesn't include strange non-printing characters instead of normal spaces.