topic Re: Function validate Number phone in SAS Programming

Function validate Number phone

vvferreira — Wed, 16 Aug 2023 15:34:24 GMT

Hello Guys,

is there currently any function that can validate the phone number, mobile?

Re: Function validate Number phone

Reeza — Wed, 16 Aug 2023 15:39:15 GMT

Validate as in check that the format is correct, or validate as in check that it's an operational phone number?

Re: Function validate Number phone

vvferreira — Wed, 16 Aug 2023 15:42:23 GMT

Hi, @Reeza,
I would just like to validate if format is correct.

Re: Function validate Number phone

Reeza — Wed, 16 Aug 2023 15:51:22 GMT

A quick google search shows a lot of variation in this topic.

Please provide some sample input data and expected output to demonstrate your problem. As you can see from the posts above there can be many variations in the source data and we're obviously unfamiliar with your data.

Re: Function validate Number phone

ballardw — Wed, 16 Aug 2023 15:58:34 GMT

Be aware that just a string of digits is insufficient. You need the spaces, dashes or whatever to separate out parts like, in US, Area-code and number.

Found this out with a set of "phone numbers" that had no spaces that included foreign country codes. Treated as US numbers and was dialing Colorado instead of Brazil.

Re: Function validate Number phone

vvferreira — Wed, 16 Aug 2023 17:04:12 GMT

Thanks Reeza,

I'm a new member and I'm still getting used to it here 🙂

Re: Function validate Number phone

LillyBates — Mon, 18 Nov 2024 09:09:43 GMT

It’s true that without seeing some sample input and expected output, it’s tricky to give advice. There are so many variations in data formatting that can make a big difference in how it’s processed. When I was working on a form validation project that needed phone numbers for verification, using real examples helped figure out where things got stuck. We used Tardigrada for quick verification checks to make sure inputs were actually functional numbers. If you share a couple of sample rows of your data, it’ll make it easier to spot patterns and suggest fixes that match what you're trying to do.