topic Re: can i have if statement with another if statement in it? in SAS Programming

can i have if statement with another if statement in it?

Kayla_Tan222 — Tue, 09 Jul 2019 11:41:53 GMT

Hi all, was wondering can I have a if statement, and then the program will run the if statement in it if the condition is fulfill with the first if statement?

Here's my code below., but this is not work

if ratecde^=1000 or ratecde^=coin or ratecde^= then

if test2=10 then

cov_type='MD1';

else if test2=11 then

cov_type='MD2';

else if test2=12 then

cov_type='MD3';

else if test2=14 then

cov_type='MD4';

else if test2=29 then

cov_type='MD5';

else

cov_type='MD6';

RUN;

Re: can i have if statement with another if statement in it?

PeterClemmensen — Tue, 09 Jul 2019 11:46:00 GMT

What does the log say?

Re: can i have if statement with another if statement in it?

PaigeMiller — Tue, 09 Jul 2019 11:58:26 GMT

if ratecde^=1000 or ratecde^=coin or ratecde^= then do;
    if test2=10 then cov_type='MD1';
    else if test2=11 then cov_type='MD2';
    else if test2=12 then cov_type='MD3';
    else if test2=14 then cov_type='MD4';
    else if test2=29 then cov_type='MD5';
end;
else cov_type='MD6';

Re: can i have if statement with another if statement in it?

gamotte — Tue, 09 Jul 2019 12:11:29 GMT

As shown by @PaigeMiller , you have to enclose the instructions following your fisrt if by do; ... end;

You can also avoid to use multiple if's by using a format :

proc format;
    value cov
        10="MD1"
        11="MD2"
        12="MD3"
        14="MD4"
        29="MD5"
        other="MD6"
    ;
run;

data have;
    do test2=10 to 30; 
        cov_type=put(test2,cov.);
        output;
    end;
run;

Re: can i have if statement with another if statement in it?

FreelanceReinh — Tue, 09 Jul 2019 12:13:54 GMT

@Kayla_Tan222 wrote:

Hi all, was wondering can I have a if statement, and then the program will run the if statement in it if the condition is fulfill with the first if statement?

Hi @Kayla_Tan222,

Yes, you can, but the condition "ratecde^= " is incomplete: the "not equal" operator (^=) must be followed by a value, perhaps you mean a numeric missing value (denoted by a period) in this case: ratecde^=.

However, in this case and also with any other constant value (except 1000) that you might insert there, your initial IF condition would always be met (and hence be redundant) because ratecde cannot equal 1000 and the other value at the same time.