topic Help for REGEX in SAS Data Science

Help for REGEX

YannRC — Mon, 12 Jan 2026 23:24:18 GMT

Hi,

I am a beginner in Regex and it's very difficult to understand some errors. I want to find 30 kms or 30 km, or 30 kilometers

REGEX: [0-9][0-9] km(s)?.

I Try with that only for km or kms but I have always a error with a escape character and I don't understand when I have to add this one.

Re: Help for REGEX

Tom — Tue, 13 Jan 2026 01:07:44 GMT

Can you provide more details of what you have tried?
Are you trying to write CODE? If so show the code. Provide some example input data and the expected result.

Are you trying to use REGEX is some other place? Explain where.

Be specific about the environment you are using and the version of SAS you are using and version of any front end tools like Enterprise Guide or SAS/Studio.

Re: Help for REGEX

Ksharp — Tue, 13 Jan 2026 02:37:44 GMT

Add some sample data would be very helpful to understand your question.

Here you go.

data x;
input x $80.;
if prxmatch('/\d+\s*(km|kms|kilometers)/i',x) then match=1;
 else match=0;
cards;
I want to find 30 kms 
I want to find 30 km, 
I want to find 30 kilometers 
I want to find kilometers 
;

Re: Help for REGEX

Ksharp — Tue, 13 Jan 2026 02:43:13 GMT

And could try this:
REGEX: [0-9][0-9] kms?
If you need to match dot ,you need to add escape char '\':
REGEX: [0-9][0-9] kms?\.