topic Re: FindC function in SAS Programming

FindC function

David_Billa — Sun, 10 Apr 2022 12:22:18 GMT

what is the meaning of third argument (dks, adks) in FINDC function?

Flag=findc(value,"","dks")
Flag2=findc(value,"","adks")

Re: FindC function

PaigeMiller — Sun, 10 Apr 2022 12:34:27 GMT

The documentation explains it all:

https://documentation.sas.com/doc/en/pgmmvacdc/9.4/lefunctionsref/n1mdh2gvd5potjn14jipysvzn4o7.htm

Re: FindC function

ChrisHemedinger — Sun, 10 Apr 2022 13:37:54 GMT

The third argument specifies any modifiers you want to apply to the function. These modifiers are common to the FIND* family of SAS functions and related functions like COUNT* and string manipulation functions like COMPRESS.

Use modifiers to narrow or control the characters that would fit your "find" operation. Want to find just digits? Use 'd'. Want to find digits and punctuation? Use 'dp'. The k modifier inverts the pattern, ex: 'dpk' means find anything except digits and punctuation.

So in your example, 'dks' means "any character except digits and space".

Related: these functions with modifiers are somewhat easier to understand than using regular expressions (supported in the PRX* family of functions) -- but if you love regex and want that flexibility, use those.

And there are simpler functions in the ANY* family of functions for specific patterns, like ANYALNUM to find the first alphanumeric character in a string, or NOTALNUM to find the first that's not an alphanumeric character.

Re: FindC function

David_Billa — Sun, 10 Apr 2022 13:53:19 GMT

I can understand the meaning of 'dks' now. What is 'adks' then?

Re: FindC function

ChrisHemedinger — Sun, 10 Apr 2022 14:06:57 GMT

'a' adds alphabetic characters, so 'adks' is "any character except alpha, digit, space" -- so punctuation, underscore, etc would match. These modifiers are listed in the SAS documentation for each of the functions, which @PaigeMiller linked to for FINDC.

Re: FindC function

David_Billa — Fri, 15 Apr 2022 15:11:50 GMT

@ChrisHemedinger I just ran the below step and got the value as 1 and 3 for the variables lag1 and lag2. How it is 1 and 3?

data test;
value="he_l l456#o";
lag1=findc(value,"","dks");
lag2=findc(value,"","adks");
run;

Re: FindC function

Kurt_Bremser — Fri, 15 Apr 2022 15:20:50 GMT

In the first call, the letter "h" is the first character that is not a digit and not a punctuation.

In the second call, the underline is the first character that is not a letter, not a digit and not a punctuation.