Apply function to Macro Variable

tedway — Thu, 14 Jun 2018 20:37:22 GMT

I have a macro variable and the value has a space in it. I want to keep this but also create a new variable that removes the space.

Here's my example code:

%let var = A B;

%let new_var = compress(&dept);
%put &new_var;

This makes new_var equal to the string "compress(&dept)" but I want new_var to equal "AB."

Re: Apply function to Macro Variable

Reeza — Thu, 14 Jun 2018 20:41:32 GMT

When using functions in a %LET you need to use %SYSFUNC() to tell SAS it's not text, but a function.

%let dept = A B;

%let new_var = %sysfunc(compress(&dept));
%put &new_var;

@tedway wrote:

I have a macro variable and the value has a space in it. I want to keep this but also create a new variable that removes the space.

Here's my example code:
%let var = A B;

%let new_var = compress(&dept);
%put &new_var;
This makes new_var equal to the string "compress(&dept)" but I want new_var to equal "AB."

topic Re: Apply function to Macro Variable in SAS Programming

Apply function to Macro Variable

Re: Apply function to Macro Variable