SAS regex string

user112a2 — Fri, 26 Apr 2019 15:45:21 GMT

I have a question on the below code.
Where it has \s\S\S$, is this looking for something like: " NJ$"? I have not seen \S$. Unless, this is an actual dollar sign in the string.

Also, in the ^.*(\s\S\S$).*$/$1. Is this looking at beginning of string for something like: " NJ$"? I'm not sure what the .*$/$1 is doing. I am new to regex in SAS.

Removed

Re: SAS regex string

PGStats — Sat, 01 Sep 2018 05:59:25 GMT

$ matches the end of the string. I guess this is looking for strings that end with a space followed by two non-space characters. If match, then extract those two characters to string claim_state and remove them from the string. It could be done with:

if prxmatch('/\s\S\S$/', strip(claim_txn_merchant_clean)) then do;
    claim_temp = strip(claim_txn_merchant_clean);
    drop claim_temp;
    claim_state = substr(claim_temp, length((claim_temp)-1, 2);
    claim_txn_merchant_clean = substr(claim_temp, 1, length(claim_temp)-3);
    end;

topic SAS regex string in SAS Programming

SAS regex string

Re: SAS regex string