topic Re: any function can count blank? in SAS Programming

any function can count blank?

harrylui — Mon, 09 Mar 2020 02:42:31 GMT

good day

is there any function can count the blank from name string

FACEBK AABMSW FBMEADS IRL

like there are 3 blanks over the name string

i also do some data cleansing on this record and the result is FACEBKAAB

can i using that cleansing result and scan/crosscheck the original record and show below result?

because i did the compress on my cleaned record and i wanted to keep that blank in this attempt of crosscheck

FACEBK AAB

so that i can know how well is my cleansing.

thanks in advance

Harry

Re: any function can count blank?

novinosrin — Mon, 09 Mar 2020 02:58:53 GMT


data w;
str='FACEBK AABMSW FBMEADS IRL';
count=countc(str,' ');
run;

/*Or you could use S modifier in the same COUNTC function*/

data w;
str='FACEBK AABMSW FBMEADS IRL kjh';
count=countc(str,,'s');
run;

Re: any function can count blank?

Reeza — Mon, 09 Mar 2020 03:10:40 GMT

Some other functions you may find useful, include COUNTC(), SCAN(), TRANSLATE() and COUNTW() which will count the number of words. You can use COUNTW() to find the number of words, and then loop with SCAN() to isolate each word if you want.

Re: any function can count blank?

Astounding — Mon, 09 Mar 2020 03:38:23 GMT

Character strings offer huge numbers of variations: trailing blanks (that should presumably not be counted), multiple blanks between words (that presumably should be counted) to name a few. I would try it differently:

data want;
   set have;
   n_blanks = lengthn(var) - lengthn(compress(var));
run;

Re: any function can count blank?

harrylui — Mon, 09 Mar 2020 08:56:16 GMT

thank you all for helping