topic Re: Character functions in SAS Programming

Character functions

A_Kh — Thu, 11 Feb 2021 04:37:41 GMT

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!

Re: Character functions

PeterClemmensen — Thu, 11 Feb 2021 04:49:08 GMT

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

Re: Character functions

qoit — Thu, 11 Feb 2021 05:55:14 GMT

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 */

Re: Character functions

andreas_lds — Thu, 11 Feb 2021 06:16:50 GMT

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

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

Re: Character functions

A_Kh — Thu, 11 Feb 2021 18:07:16 GMT

Yes, it is for counting occurrences.

Re: Character functions

A_Kh — Thu, 11 Feb 2021 18:08:45 GMT

thank you so much! it worked.