topic Re: strange response of countw in SAS Programming

strange response of countw

romangelzhaeuse — Sat, 18 Nov 2017 16:06:36 GMT

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;

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

64 %put "&a.";

65 %mend;

67 %test;

"4"

Re: strange response of countw

jklaverstijn — Sat, 18 Nov 2017 16:08:03 GMT

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

Re: strange response of countw

WarrenKuhfeld — Sat, 18 Nov 2017 16:13:44 GMT

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