Dear All,   Kindly provide the Solution for the following. I am trying since Moring but not able to Make It. data EMI_Form; P=100000; R=0.12; do N=1 to 12; EMI=(P*R*(1+R)**N)/(1+R)**(N-1); output; end; run;   but I am Getting this output.       P   R   N   EMI   1 100000 0.12 1 13440 2 100000 0.12 2 13440 3 100000 0.12 3 13440 4 100000 0.12 4 13440 5 100000 0.12 5 13440 6 100000 0.12 6 13440 7 100000 0.12 7 13440 8 100000 0.12 8 13440 9 100000 0.12 9 13440 10 100000 0.12 10 13440 11 100000 0.12 11 13440 12 100000 0.12 12 13440   Kindly Suggest me how to make the formula.   thanks a lot ... View more

Dear All,   I am new in the Analytics. I want to learn most of the concept. i am working on basics of do loop. but i am not able to create the formula for Compound interest. Kindly Help me in this Matter.   thanks.   codes are     data CI; principle=100000; rate=0.10; do year=1 to 10; principle+principle{(1+0.10)**10}; output; end; run;   ... View more