topic Re: How do I count the number of times a character appears in a string? in New SAS User

How do I count the number of times a character appears in a string?

klj4y — Fri, 04 Dec 2020 01:32:53 GMT

Count the number of times the string ‘ ? ‘ occurs in variable line. Choose any method that works reliably. Regardless of method, assume that a line won’t consist entirely of ‘ ? ‘’s.

Re: How do I count the number of times a character appears in a string?

mkeintz — Fri, 04 Dec 2020 01:56:02 GMT

So what strategies, in words, do you think might work?

Re: How do I count the number of times a character appears in a string?

klj4y — Fri, 04 Dec 2020 02:14:18 GMT

I would think the countc function. We were not provided data to test it on so i'm not sure how it would work.

Re: How do I count the number of times a character appears in a string?

ballardw — Fri, 04 Dec 2020 02:44:03 GMT

Easy enough to test a function. Find the required parameters from the documentation of function and then use it. A vast majority of the functions in the SAS documentation have at least one example.

From Countc:

data test;
   string  = 'Baboons Eat Bananas     ';
   a       = countc(string, 'a');
   b       = countc(string, 'b');
   b_i     = countc(string, 'b', 'i');
   abc_i   = countc(string, 'abc', 'i');
      /* Scan string for characters that are not "a", "b", */
      /* and "c", ignore case, (and include blanks).       */
   abc_iv  = countc(string, 'abc', 'iv');
      /* Scan string for characters that are not "a", "b", */
      /* and "c", ignore case, and trim trailing blanks.   */
   abc_ivt = countc(string, 'abc', 'ivt');
run;

Key part are the source, the variable String above, and the character list to search for, the second parameter. The 3rd optional parameter has to do with ignoring letter case, adding or excluding certain types of characters that are hard to type and keep in code such as Tab or control characters (ancient stuff from teletype but include things like the "ring bell", vertical space without end of line, and stuff)

Re: How do I count the number of times a character appears in a string?

Reeza — Fri, 04 Dec 2020 04:16:56 GMT

Classmates or hiring exam? https://communities.sas.com/t5/SAS-Programming/How-to-count-upcase-letter-from-a-string-in-Base-SAS/m-p/703460