Perl regular expression

[Lauren22]

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

[Lauren22]

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

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

[actuarial]

What are you trying to do?

[Lauren22 · Accepted solution]

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.

[ballardw]

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>