The data I have is like following with thousands of rows: APP n amount rate1 rate2 1 84 10000 0.09 0.095 2 60 5000 0.1 0.12 3 12 1000 0.13 0.135 4 24 5000 0.12 0.124   For each row I need to calculate something like: data one; payment1=mort(amount, ., rate1/12,n); int1_inc_yr1 = CUMIPMT (rate1/12, n, amount, 1, 12, 0); bal1_endyr1 = AMOUNT - CUMPRINC (rate1/12, n, amount, 1, 12, 0); int1_inc_yr2 = CUMIPMT (rate1/12, n, amount, 13, 24, 0); bal1_endyr2 = bal_endyr1- CUMPRINC (rate1/12, n, amount, 13, 24, 0); ... ... run; ...<For all the years in term, for 120 term, this will go for 12 years, this is not fixed as each application will have a different term> ...<This then I need to repeat for other Interest Rates as well, in data I have given 2 rates, it may go upto 5 rates> the output I need is: For each row(application), all the 'Interest Accumulated' and 'End of Year Principal Balance' in each year during it's term...   I tried PROC LOAN to do this but supplying each row one at a time takes too long. Any idea on how to do this efficiently in DATA step or any other method?   (P.S. - I then have to use this output for further calculations in PROC IML. Each row will interact with other matrces there.) ... View more

Hi I am trying to generate X_1 = A_1; X_2 = A_1 A_2; ...X_5 = A_1 A_2 A_3 A_4 A_5; and following code does the job %macro temp; %let x_1 = A_1; %do i= 2 %to 5; %let x_&i. = &&x_%eval(&i.-1). %str( A_&i.); %put &&x_&i.; %end; %mend; %temp; The issue is on every iteration it's trying to resolve &X_ as well and thus throwing a warning! What am I doing wrong and how can I rectify it? Thanks a lot in advance. ... View more