strange response of countw

[romangelzhaeuse]

When I tried to write a loop over some arguments countw gave me the answer that "where Gruppe=1!where Gruppe=2" consists of four words when using "!" as delimiter. Shouldn't it be 2? 

I used countw as shown in the log below.

61 %macro test;

62

63 %let a=%sysfunc(countw(where Gruppe=1!where Gruppe=2),!);

64 %put "&a.";

65 %mend;

66

67 %test;

"4"

[jklaverstijn · Accepted solution]

Looking at parentheses the ! is interpreted as a parameter for %sysfunc and not of countw. You're better of with

%sysfunc(countw(&Beds.,!));

Hope this helps,

- Jan

[WarrenKuhfeld]

Your parentheses are in the wrong place.   This works.  I deleted other extra characters that you do not need.

%macro test;
%let a=%sysfunc(countw(where Gruppe=1!where Gruppe=2,!));
%put &a;
%mend;
%test