Solved it! I needed to add a statement in the beginning of the second DO loop to initiate the counter. DATA test;
SET schedule;
BY MAST_CTRCT_ID MONTH;
IF FIRST.MAST_CTRCT_ID THEN DO;
BOM_PRINCIPAL=EQUIPMENT_COST;
INT_PMT=(EQUIPMENT_COST* ((INT_RATE/100)/12));
PP_PMT=CORE_PMT_USD_AMT - (EQUIPMENT_COST * ((INT_RATE/100)/12));
EOM_PRINCIPAL= (EQUIPMENT_COST + (EQUIPMENT_COST * ((INT_RATE/100)/12)) - CORE_PMT_USD_AMT);
END;
ELSE DO;
EOM_PRINCIPAL + 0;
BOM_PRINCIPAL=EOM_PRINCIPAL;
INT_PMT=BOM_PRINCIPAL * ((INT_RATE/100)/12);
PP_PMT=CORE_PMT_USD_AMT - (BOM_PRINCIPAL * ((INT_RATE/100)/12));
EOM_PRINCIPAL= (BOM_PRINCIPAL + (BOM_PRINCIPAL * ((INT_RATE/100)/12)) - CORE_PMT_USD_AMT);
END;
RUN;
... View more