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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.