select a condition and update the value of the other existing variable before creating new variables

[CHL0320]

Hi Community;

I need a solution to select the condition on the first character variable then updates the value of the other character variables before creating the final character variable. For example.

DATA have;
input a $ b $ c $;
datalines;
0 2 7
1 5 2
1 7 3
0 3 1
;
run;

The request is if a is 1 then update the value in b and c as 

when  a="1" and then when b or c=1  then the new value of  b or c=0.07;

when  a="1" and then when b or c=2 then the new value of  b or c=0.14;

when  a="1" and then when b or c=3  then the new value of  b or c=0.36;

when  a="1" and then when b or c=4  then the new value of  b or c=0.64;

when  a="1" and then when b or c=5  then the new value of  b or c=1;

when  a="1" and then when b or c=6  then the new value of  b or c=3;

when  a="1" and then when b or c=7  then the new value of  b or c=5;

The final step is to create a new character variable d as the sum of b and c. 

Therefore the wanted table will be like

a      b      c       d

0      2      7        .

1      1    0.14   1.14

1     5     0.36   5.36

0      3      1       .

All the variables are character variables.

Thank you for your help. 

[ScottBass]

This doesn't look particularly difficult.  Can you post the code you've attempted, and describe what didn't work?

Read the doc on IF/THEN/ELSE and SELECT/WHEN/OTHERWISE.

[CHL0320 · Accepted solution]

Thank you and I am able to find what is wrong in my previous code. Thank you so much.

DATA have;
input a $ b $ c $;
datalines;
0 2 7
1 5 2
1 7 3
0 3 1
;
run;

data want;
set have;

if a="1" then
DO;
select(b);
when ("1") b="0.07";
when ("2") b="0.14";
when ("3") b="0.36";
when ("4") b="0.64";
when ("5") b="1";
when ("6") b="3";
when ("7") b="5";
otherwise;
end;

select(c);
when ("1") c="0.07";
when ("2") c="0.14";
when ("3") c="0.36";
when ("4") c="0.64";
when ("5") c="1";
when ("6") c="3";
when ("7") c="5";
otherwise;
end;

e=b+c;
d=put(e,4.2);
drop e;
END;
run;