09-13-2017 06:14 AM
Hey everyone, I have written some codes to calculate the P_margin for 4 different years. the code and the results are shown below. But I would like to have S for year 1 eq to 1. How can I modify this code ?
Thanx so much
data B; S=1; P=0.02; do year=1 to 4; S=S*(1-P); P_marg=S*P; output; end; run;
09-13-2017 06:45 AM
There's another way to interpret your request. It's possible you want exactly the same numbers you got from your original program, but with S=1 on the first observation. For that:
do year=1 to 4;
if year=1 then replacement_S=1;
else replacement_S = S;
P_marg = S * P;
rename replacement_S = S;
Need further help from the community? Please ask a new question.