topic using wildcards in regex in SAS Data Science

using wildcards in regex

McSquarewolf — Wed, 08 Sep 2021 13:45:12 GMT

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')

Re: using wildcards in regex

Tom — Wed, 08 Sep 2021 14:09:33 GMT

So that is not SAS code. What is the SAS code you are running? Are just use PROC SQL to submit that code directly to SNOWFLAKE? If so please show the SAS code. If you get an error message include the SAS log.

Make sure to use the Insert Code or Insert SAS code button on the forum editors menu bar to paste in the text from your log or program.

Re: using wildcards in regex

McSquarewolf — Wed, 08 Sep 2021 17:17:11 GMT

That's a good point, my fault. Where I'm having trouble is using this
syntax in a pass through to snowflake in a sas job.

Re: using wildcards in regex

Tom — Thu, 09 Sep 2021 03:27:56 GMT

Please show the actual code you used.

SAS has three types of comments and none of them are in the snippet you showed.