Character functions

[A_Kh]

Hi,
I really need your help guys!

there is a char variable with "broken bar "(|) delimited string.
I need to count how many (|) in the string.

Please give your expertise!

thank you!

[PeterClemmensen]

Do you need to count the occurences of "(|)" or "|"?

[qoit · Accepted solution]

Hope below helps 🙂

*If delimted by |   ;
data _null_;
	a = 'a|b|c|';
	b = count(a,"|");
	put a= b=;
run;
/* LOG - a=a|b|c| b=3 */


*If delimited by (|)    ;
data _null_;
	a = 'a(|)b(|)c(|)';
	b = count(a,"(|)");
	put a= b=;
run;

/* LOG - a=a(|)b(|)c(|) b=3 */

[A_Kh]

thank you so much! it worked.

[A_Kh]

Yes, it is for counting occurrences.

[andreas_lds]

SAS functions are documented at https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=lefunctionsref&docsetTarg...

If you want to count a single char, countc should be your first-choice.