The LOAN Procedure

OUT= Data Set

The OUT= option writes the loan amortization schedule to an output data set. The OUT= data set contains one observation for each payment period (or one observation for each year if you specified the SCHEDULE=YEARLY option). If you specified the START= option, the DATE variable denotes the date of the payment. Otherwise, YEAR and period variable (SEMIMONTH, MONTH, QUARTER, or SEMIYEAR) denote the payment year and period within the year.

The OUT= data set contains the following variables:

  • DATE, date of the payment. DATE is included in the OUT= data set only when you specify the START= option.

  • YEAR, year of the payment period. YEAR is included in the OUT= data set only when you do not specify the START= option.

  • PERIOD, period within the year of the payment period. The name of the period variable matches the INTERVAL= specification (SEMIMONTH, MONTH, QUARTER, or SEMIYEAR.) The PERIOD variable is included in the OUT= data set only when you do not specify the START= option.

  • BEGPRIN, beginning principal balance

  • PAYMENT, payment

  • INTEREST, interest payment

  • PRIN, principal repayment

  • ENDPRIN, ending principal balance