Thanks for your reply. I was able to create years, but in the process, the value of capital and interest also got fixed with the years. Maybe I have placed the code at a wrong place. Please, can you let me know the correct location?     This is what my initial code was:    data file; format Year Month Capital Interest; Principal = 4000; Deposits = 90; do until (Principal >= 100000); Interest = (Principal + Deposits) * 0.01; Capital = Interest + Capital; Month + 1; output; end; run; ... View more

Thank you sir, the years are formed but I think i have written the code at some incorrect location, and the values of capital and interest are changed. Can you help me where to place the above command? ... View more

Please help me in writing a DO loop code for variables that are fixed during a year, and change after the year-end. For example, variable changes from A to B and then to C at the end of 12 month period.  ... View more