How to do multiple if statements

[sas_user409]

Hi,

I am new to sas EG so unsure how to do this:

I am trying to write a small bit of code within my proc sql that takes a column of phone numbers and creates a new flag column. I want the new column to produce a Y when the phone number is: not empty, 11 digits long, only digits and not equal to '11111111111' and a 'N' otherwise.

Thanks in advance.

[Kurt_Bremser · Accepted solution]

In SQL, you need CASE:

proc sql;
create table want as
select
  have.*,
  case
    when 
      length(have.phone) = 11 and notdigit(compress(have.phone," ")) = 0
      and have.phone ne "11111111111"
    then 1
    else 0
  end as flag
from have;
quit;

But it is shorter in a DATA step:

data want;
set have;
if
  length(phone) = 11 and notdigit(compress(phone," ")) = 0
  and phone ne "11111111111"
then flag = 1;
else flag = 0;
run;

I used numerical 1 and 0 because these can immediately be used as Boolean values later in the code.

[sas_user409]

Thanks so much for your help!

[sas_user409]

I also have a case statement for email column:
case
when
email is not missing
then 1
else 0
end as flag

could you please tell me how would I also include to say when email does not contain '@' then flag it as 0

[Kurt_Bremser]

Use the INDEXC or FINDC function to detect a single character in a string.