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."
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."
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."
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.