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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: