@novinosrin wrote: Not sure, as I don't comprehend the flow of data in your process but a simple demo %let k="ironman@marvel.com" "thor@marvel.com" "hulk@marvel.com";
%put &k;
%let k1=%sysfunc(compress(%superq(k),%str(%")));
%put &k1 ; We're trying to store the string in the macro variable as an observation. Your solution works somewhat but what if there are no spaces and the data coming in looks like %let k="ironman@marvel.com""thor@marvel.com""hulk@marvel.com"; Is it possible to add spaces or remove the double quotes without compressing the spaces?
... View more