topic Re: IF Then Statement Not Working Properly in New SAS User

IF Then Statement Not Working Properly

K_Wils15 — Thu, 15 Apr 2021 04:13:05 GMT

Hi. I was wondering if someone could help me with my code. Here it is:

data 6;
set 5;
if Q34 = "White" then Race = 1;
if Q34 = "Black or African American" then Race = 2;
if Q34 = "Asian" then Race = 3;
Else Race = 4;
run;

However, in the proc print, I have noticed it does not work correctly as you can see here:

White should be 1 under race but it comes up as 4, do you know why this is?

Re: IF Then Statement Not Working Properly

r_behata — Wed, 14 Apr 2021 21:56:27 GMT

Your If conditions need to be mutually exclusive. Try.

if Q34 = "White" then Race = 1;
else if Q34 = "Black or African American" then Race = 2;
else if Q34 = "Asian" then Race = 3;
Else Race = 4;

Btw, 5 and 6 are not valid names for the sas datasets.

Re: IF Then Statement Not Working Properly

ballardw — Wed, 14 Apr 2021 22:02:54 GMT

@K_Wils15 wrote:

Hi. I was wondering if someone could help me with my code. Here it is:

data 6;
set 5;
if Q34 = "White" then Race = 1;
if Q34 = "Black or African American" then Race = 2;
if Q34 = "Asian" then Race = 3;
Else Race = 4;
run;

However, in the proc print, I have noticed it does not work correctly as you can see here:

White should be 1 under race but it comes up as 4, do you know why this is?

The Else as you have written the code only applies to the Q34="Asian". So when Q34="White" the Else is executed instead of the assignment of 3.

@r_behata has the correct approach for the If/then/else structure. I'm just providing some detail as to why your code was wonky.

Re: IF Then Statement Not Working Properly

WarrenKuhfeld — Wed, 14 Apr 2021 23:33:28 GMT

Both replies are of course correct. In general, you will find that standard parts of SAS that have been successfully used for decades, ALWAYS work properly. If you are not getting the results you expect, it is a user error not a SAS error.

Re: IF Then Statement Not Working Properly

K_Wils15 — Thu, 15 Apr 2021 03:35:35 GMT

Thank you! Thanks for catching that, I just deleted the first part of the name because I named it after the survey. Thank you.

Re: IF Then Statement Not Working Properly

K_Wils15 — Thu, 15 Apr 2021 03:36:22 GMT

Thank you for explaining!

Re: IF Then Statement Not Working Properly

K_Wils15 — Thu, 15 Apr 2021 03:37:59 GMT

Got it! Thanks Warren!