topic Re: Recode new variable in SAS Programming

Recode new variable

aowais — Fri, 12 Jul 2019 19:45:01 GMT

Hello,

I'm trying to create a variable from two others which should be missing if both are missing, '1' if both are '1' and '0' otherwise. I know how to do this in longhand (see below), but is there a shorter way?

data two; set one;

if var1 = . and var2 = . then new_var = .;

else if var1 = 1 and var2 = 1 then new_var = 1;

else new_var = 0;

run;

Re: Recode new variable

novinosrin — Fri, 12 Jul 2019 19:52:56 GMT

if coalesce(var1,var2)>. then new_var=var1=var2=1;

Re: Recode new variable

Reeza — Fri, 12 Jul 2019 20:27:27 GMT

Same answer as your previous question here:
https://communities.sas.com/t5/SAS-Programming/Recode-multiple-variables/m-p/573178

Re: Recode new variable

aowais — Fri, 12 Jul 2019 21:45:32 GMT

I tried that, but it didn't work.

Re: Recode new variable

aowais — Fri, 12 Jul 2019 21:45:53 GMT

Thank you. This works.

Re: Recode new variable

Reeza — Fri, 12 Jul 2019 21:49:26 GMT

Do you understand the calculations happening there? You may want to look into IFN() as well, especially for dealing with a single variable, which has a fourth(or 5th) parameter to deal with MISSING.