Using wildcards with regex_count. In snowflake directly, this syntax below will be accepted. But in sas there is an issue with the wildcard at the end that I can't figure out how to workaround. It seems to look at it like I'm incorrectly trying to comment something out. Syntax below is looking for "all your questions" essentially, with word distance in between and a wildcard on question* to account for text-to-speech inaccuracies. Even though I could use more iterations of question(s)(ing), would like to know if anyone has a solution for future wildcard needs like this scenario. Thanks you for any help you can provide in answering this question. REGEXP_COUNT(LOWER(TranscriptFieldName), '\\b(all)([,.!?]? ?\\b[^\\s]+\\b[,.!?]?){0,3}[,.!?]? (your|you\'re)([,.!?]? ?\\b[^\\s]+\\b[,.!?]?){0,3}[,.!?]? question[a-z]*\\b')
... View more