topic Re: sas, regex, numbers, substring, prxchange in SAS Programming

sas, regex, numbers, substring, prxchange

user112a2 — Fri, 26 Apr 2019 17:41:59 GMT

I need help with the below code. I do not see how this is extracting the number from this address line text. When it says \D/ / I thought this replaces the digits with a space. I know the second part here is taking the substring up to the first space in the address line text. But, then I do not see how this is extracting the numbers. I pulled up the data set and it looks like this does work. Please help me understand how this is working.

Removed

Re: sas, regex, numbers, substring, prxchange

Jagadishkatam — Mon, 05 Nov 2018 19:36:05 GMT

Here the \D represents anything but not a digit. Because of which it is suppressing the every other data except the digit.

Re: sas, regex, numbers, substring, prxchange

ChrisNZ — Mon, 05 Nov 2018 20:11:16 GMT

Function compress() would be a lot faster for this simple change.