using wildcards in regex

[McSquarewolf]

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

[Tom]

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.

[McSquarewolf]

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.

[Tom]

Please show the actual code you used.  

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