topic how to count the frequency of a letter in a string in SAS Procedures

how to count the frequency of a letter in a string

Mike_Davis — Wed, 18 Jul 2012 14:26:48 GMT

Hello everyone,

I want to count how many specified letter in a string,

such as:

%let have=123#45#678#9; we need to count how many '#' in the string.

in this case there are total three '#' in the string.

Thanks

data one;

a="123#45#678#9";

b=somefunction(a,'#');

run;

Haikuo — Wed, 18 Jul 2012 14:30:37 GMT

How about countc()?

data one;

a="123#45#678#9";

b=countc(a,'#');

put b=;

run;

Mike_Davis — Wed, 18 Jul 2012 14:31:23 GMT

data one;

a="123#45#678#9";

b=count(a,'#');

run;