Thank you very much for your quick response.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.