Count how many "$" in each record

yichentian226 — Fri, 23 Apr 2021 16:54:11 GMT

Hi,

I have a column named journey. Under journey there're rows, eg: abc$def$fgu. Now I want to count how many "$" in each record. In this case there will be three. Any help is appreciated!

Re: Count how many "$" in each record

ballardw — Fri, 23 Apr 2021 17:15:54 GMT

@yichentian226 wrote:

Hi,

I have a column named journey. Under journey there're rows, eg: abc$def$fgu. Now I want to count how many "$" in each record. In this case there will be three. Any help is appreciated!

The SAS Countc function counts number of occurrences of a character in a variable:

data example;
   journey="abc$def$fgu";
   dollarcount = countc(journey,"$");
run;

Your example only shows 2 $ signs. eg: abc$def$fgu.

If you want to count the number of things SEPARATED by the $

data example2;
   journey="abc$def$fgu";
   dollarcount = countw(journey,"$");
run;

Countw counts "words". The second parameter would be a list of characters used to separate the pieces of the value. This just uses the $ sign to separate.

Re: Count how many "$" in each record

yichentian226 — Fri, 23 Apr 2021 18:13:58 GMT

THANKS SO MUCH! You rock!

topic Count how many "$" in each record in SAS Programming

Count how many "$" in each record

Re: Count how many "$" in each record

Re: Count how many "$" in each record