searching for numeric string in character data

Elliott — Wed, 11 Nov 2020 23:24:38 GMT

Hello,

I need some help with transactional data and I am not sure where to begin.

I need to search transaction data in a comments field for a numeric string (Account Number).

I have a data set with multiple rows with a unique id and time stamp to group all records together a chat transcript.

I need to pull the account number from the comments field without knowing what it is. I only know it will be 16 digits. The client may have entered it all in one string or it could be like xxxx xxxx xxxx xxxx. Hopefully there is no other way.

Can anyone assist me with this?

Thanks in Advance.

Elliott

Re: searching for numeric string in character data

ChrisNZ — Thu, 12 Nov 2020 01:02:12 GMT

One way:

where prxmatch('/\d{16}/',compress(COMMENT,' '));

This looks for 16 digits in a string where spaces are removed. Suitable?

topic searching for numeric string in character data in SAS Programming

searching for numeric string in character data

Re: searching for numeric string in character data