topic Re: Help with do loop in SAS Programming

Help with do loop

Qiuyue — Wed, 13 Sep 2017 10:14:53 GMT

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;

Re: Help with do loop

ChrisBrooks — Wed, 13 Sep 2017 10:32:31 GMT

Try this

data B;                                                                                                                                      
	S=1;                                                                                                                                      
	P=0.02;  
   
	do year=1 to 4;  
		if year=1 then s=1;
		else S=S*(1-P);                                                                                                                           
		P_marg=S*P;   
		output;
	end;                                                                                                                                        
run;

Re: Help with do loop

PeterClemmensen — Wed, 13 Sep 2017 10:33:28 GMT

How about simply

data B;
   S=1;P=0.02;Year=1;P_marg=S*P;output;
      do year=2 to 4;
        S=S*(1-P);
        P_marg=S*P;
      output;
 end;
run;

Re: Help with do loop

Astounding — Wed, 13 Sep 2017 10:45:32 GMT

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:

data B;

S=1;

P=0.02;

do year=1 to 4;

S=S*(1-P);

if year=1 then replacement_S=1;

else replacement_S = S;

P_marg = S * P;

output;

end;

drop S;

rename replacement_S = S;

run;