topic Re: Perl regular expression in SAS Programming

Perl regular expression

Lauren22 — Tue, 29 Aug 2023 15:32:45 GMT

How do i use perl regular expression to pick up -00- in the 4th and 5th position of an ssn number?

Re: Perl regular expression

Lauren22 — Tue, 29 Aug 2023 15:50:48 GMT

'/(\d{3})-(00)-(\d{4})/'

i tried the code above but didn't work... thanks.

Re: Perl regular expression

actuarial — Tue, 29 Aug 2023 15:55:12 GMT

What are you trying to do?

Re: Perl regular expression

Lauren22 — Tue, 29 Aug 2023 15:57:53 GMT

Am trying to clean a data set with fake ssn like this one 000-00-0000, most of the fake one have 00 in the 4 and 5th position or the 0000 as the last four digits.

Re: Perl regular expression

ballardw — Tue, 29 Aug 2023 16:16:40 GMT

One thing that you may want to check is if the value is actually a character value. SAS has a SSN format that displays numbers intended to be SSN with dashes and may make you think it is character when actually numeric. The regular expressions tend not work as expected on actual numeric values.

If character I might look to SCAN as well

if scan(variable,2,'-')='00' or scan(variable,3,'-')='0000' then <whatever when found>