BookmarkSubscribeRSS Feed
abhinayingole
Obsidian | Level 7

Hi there

 

%LET x = )AL);

 

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

2 REPLIES 2
PaigeMiller
Diamond | Level 26
%let y=%sysfunc(compress(%superq(x),%str(%))));
%put &=y;
--
Paige Miller
Astounding
PROC Star

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);

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 924 views
  • 2 likes
  • 3 in conversation