Hi, Does anyone know if "countw" can skip the space between single quoted words? Here is my code: %macro colnames1(colnames1); %put "number of names in columns is " %sysfunc(countw(&colnames1)); %mend colnames1; %colnames1(Contracts age 'young boys'n 'young girls'n); run; The result is: %macro colnames1(colnames1); %put "number of names in columns is " %sysfunc(countw(&colnames1)); %mend colnames1; %colnames1(Contracts age 'young boys'n 'young girls'n); "number of names in columns is " 6 run; There should only be 4 words ('contracts', 'age', 'young boys' and 'young girls'). The program is counting the spaces in between the single quotes. I further tried to following but still didn't get the results I wanted (still gave me 6 words). %put "number of names in columns is " %sysfunc(countw(&colnames2%str(""))); THANKS!
... View more