topic removing ')' form macro variable in SAS Programming

removing ')' form macro variable

abhinayingole — Tue, 28 Dec 2021 18:06:37 GMT

Hi there

%LET x = )AL);

please help me with removing / compressing closing brackets from above code.

Re: removing ')' form macro variable

PaigeMiller — Tue, 28 Dec 2021 18:43:03 GMT

%let y=%sysfunc(compress(%superq(x),%str(%))));
%put &=y;

Re: removing ')' form macro variable

Astounding — Tue, 28 Dec 2021 19:14:56 GMT

My choice is to avoid quoting functions when possible. As long as your string does not contain any double quotes, you can use:

%let x = %scan("&x", 1, ")" );

Technically, this does not remove the ). Rather, it selects the first word from the original string (in quotes), using both double quotes and ) as delimiters. So it would not work for:

%let x = A)B);