I want to search for a list of words in a long text in a column (. If any word in the list exists in the column, the row be in the output dataset. Please see my partial code. I want to search for dog,cat and boat in a column called "Column" WL = PRXPARSE("/dog|cat|boat/"); do i=1 to N; position = PRXMATCH( WL ,Column(i)); if position ge 1 then do; ALERT_TRIGGER_TXT= SUBSTR(Column(i),max(1,position-200),position-1)|| '*' || SUBSTR(A_TSC_SUSP_TXT(i),max(1,position),position+200) ; output; end; end; Is there other text searching function that would make the program faster?
... View more