I have a macro variable that is a list of variable names delimited by spaces. I want to make a new macro variable that is the count of the number of variable names in the macro list. I thought we had a macro function that would do this but I can’t seem to find it. Any general hints or a push in the right direction would be much appreciated.
With %SYSFUNC() almost any function is potentially a macro function now.
%let n=%sysfunc(countw(&list,%str( )));
With %SYSFUNC() almost any function is potentially a macro function now.
%let n=%sysfunc(countw(&list,%str( )));
Thank you, Tom.
That worked like a charm!
Hi Tom,
%let n=%sysfunc(countw(&list,%str());
In this code, what is the function of %str())?
Thanks !!!
It tells the function which characters to consider as causing word boundaries. So %STR( ) tells to only consider a blank as the delimiter for work boundaries.
If your computer uses ASCII characters, then the default delimiters are as follows:
blank ! $ % & ( ) * + , - . / ; < ^ |
Thanks, Tom.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.