topic Re: Identify phone numbers with all the same digits in one phone number in SAS Programming

Identify phone numbers with all the same digits in one phone number

lizzy28 — Thu, 05 May 2022 19:26:52 GMT

Hi all,

Is there a way to identify phone numbers with all the same digits in one phone number? For example, the phone numbers like 1111111111, 5555555555, 9999999999.

Thanks a lot!

Lizzy

Re: Identify phone numbers with all the same digits in one phone number

PaigeMiller — Thu, 05 May 2022 19:45:15 GMT

Step 1: turn the phone number into a sequence of ten numeric (not character) single digit values.

Step 2: determine the min and max of these 10 single digit values, if the min=max then you have all the same digits

Example:

data have;
    phone_number='1111111111';
    array digit digit1-digit10;
    do i=1 to 10;
        digit(i)=input(substr(phone_number,i,1),1.);
    end;
    delta=max(of digit(*))-min(of digit(*));
    drop i;
run;

Re: Identify phone numbers with all the same digits in one phone number

FreelanceReinh — Thu, 05 May 2022 20:23:32 GMT

Hi @lizzy28,

Alternatively, you can use character functions. For example, the criterion

compress(t,first(t))=' '

should work for non-empty digit strings t (without hyphens, parentheses, leading blanks, etc.).

Re: Identify phone numbers with all the same digits in one phone number

mkeintz — Thu, 05 May 2022 23:12:39 GMT

If it's a 10 digit number then

if mod(phone_number,1111111111)=0 then flag=1;
else flag=0;