Online File

How to use this page

---

Rick Aster: Professional SAS Programming Shortcuts: Contents

Chapter 59
Program
Loan payment schedule (ODS table)

---

DATA _NULL_;
   FILE PRINT ODS=(VARIABLES=(MONTH (FORMAT=F5.)
       PRINCIPAL (FORMAT=COMMA10.2)
       PAYMENT (FORMAT=COMMA8.2) RATE (FORMAT=F8.6)
       INTEREST (FORMAT=COMMA8.2)));
   PRINCIPAL = 100000;
   RATE = .006250;
   N = 12;
   PAYMENT = MORT(PRINCIPAL, ., RATE, N);
   DO MONTH = 1 TO N;
      INTEREST = PRINCIPAL*RATE;
      PUT _ODS_;
      PRINCIPAL = PRINCIPAL - PAYMENT + INTEREST;
      END;
RUN;