As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.
Here are some tips for How to share your SAS knowledge with your professional network.
Difference between revisions of "Tips:Counting Words in a List"
m (fix typos)
|Line 23:||Line 23:|
Revision as of 12:27, 26 June 2009
You can count the number of words in a list by using one of the counting functions: COUNT, COUNTC, COUNTW. Simple macros can be written to incorporate the functionality of these functions into the macro langauge. The following assume that the word delimiter is a blank, and both correctly allow for multiple blanks between words.
%macro countw(list=); %sysfunc(countw(&list)) %mend countw;
The %COUNT macro counts embedded blanks and adds one to the total.
%macro count(list=); %eval(%sysfunc(count(%cmpres(&list),%str( )))+1) %mend count;
A list of typical Anchorage Zoo animals demonstrates the use of these macros.
%let critters = wolverines grizzlies moose;
%put there are %countw(list=&critters) animals at the zoo; %put there are %count(list=&critters) animals at the zoo;
Submitted by Art Carpenter. Contact me at my Discussion Page.