Hi Reeza, Thanks for your response. I will definitely take care of that.   Yes, I am able to sort some the errors that I made by following the previous responses. Yes, I need help in calculating the total  amount at end of the term , compounded annually  as well as compounded monthly. the amount is 50000, annual interest is 7% term deposit is for 25 years.   for the same I have done this code : it will give the amount at monthly levels.   but, I need to figure it out at yearly levels also.   data earn; capital=500000; /** initial Amount **/ int_r=0.07/12; /*** for interest at monthly level **/ do year=1 to 25; /** for term deposit 25 years **/                                       do month=1 to 25*12; /** for monthly levels years multiplied by 12  **/ int_m=capital*int_r; /** calculating the interest at monthly levels **/ capital+int_m;   /** the interest that i am earning each month by accumulating at int_m variable    **/  output; end; end; run;   Please suggest me on that as well as improvements that I need to do. thanks          ... View more

thank you for your response, the first name & middle name has no split in between. yes, the middle name is two letter abbreviation. yes, its start with the first capital letter as the first name ends. ... View more

yes please correct me on that. data earn_4; amount=500000; int_rate=0.07; do year=1 to 25; interest_y=amount*int_rate; amount+interest_y; do month=1 to 25*12; interest_m=amount*(0.07/12); amount+interest_m; output; end; end; run; ... View more

thanks for suggesting.   but its not  working as desired.     the code for the same is :     data earn_4; amount=500000; int_rate=0.07; do year=1 to 25; interest_y=amount*int_rate; amount+interest_y; do month=1 to 25*12; interest_m=amount*(0.07/12); amount+interest_m; output; end; end; run; it giving numbers in exponential form. please suggest.  ... View more

Hi, Thanks for your response I have done it But I am stuck at how to assign a date1 to a column which as several dates in it pls see the image for reference. Y=intck("month",date1,date2) Date2 is today date Pls suggest ... View more