The COMPARE statement compares multiple loans, or it can be used with a single loan. You can use only one COMPARE statement.
COMPARE statement options specify the periods and desired types of analysis for loan comparison. The default analysis reports
the outstanding principal balance, breakeven of payment, breakeven of interest paid, and beforetax true interest rate. The
default comparison period corresponds to the first LIFE= option specification. If the LIFE= option is not specified for any
loan, the loan comparison period defaults to the first calculated life.
You can use the following options with the COMPARE statement. For more detailed information on loan comparison, see the section
Loan Comparison Details.

ALL

is equivalent to specifying the BREAKINTEREST, BREAKPAYMENT, PWOFCOST, and TRUEINTEREST options. The loan comparison report
includes all the criteria. You need to specify the MARR= option for present worth of cost calculation.

AT=( date1 date2 ... )
AT=( period1 period2 ... )

specifies the periods for loan comparison reports. If you specify the START= option in the PROC LOAN statement, you can specify
the AT= option as a list of dates expressed as SAS date literals instead of periods. The comparison periods do not need to
be in time sequence. If you do not specify the AT= option, the comparison period defaults to the first LIFE= option specification.
If you do not specify the LIFE= option for any of the loans, the loan comparison period defaults to the first calculated life.

BREAKINTEREST
BI

specifies breakeven analysis of the interest paid. The loan comparison report includes the interest paid for each loan through
the specified comparison period (AT= option).

BREAKPAYMENT
BP

specifies breakeven analysis of payment. The periodic payment for each loan is reported for every comparison period specified
in the AT=option.

MARR=rate

specifies the MARR (minimum attractive rate of return) in percent notation. The MARR reflects the cost of capital or the opportunity
cost of money. The MARR= option is used in calculating the present worth of cost.

PWOFCOST
PWC

calculates the present worth of cost (net present value of costs) for each loan based on the cash flow through the specified
comparison periods. The calculations account for down payment, initialization costs, and discount points, as well as the payments
and outstanding principal balance at the comparison period. If you specify the TAXRATE= option, the present worth of cost
is based on aftertax cash flow. Otherwise, beforetax present worth of cost is calculated. You need to specify the MARR=
option for present worth of cost calculations.

TAXRATE=rate
TAX=rate

specifies income tax rate in percent notation for the aftertax calculations of the true interest rate and present worth of
cost for those assets that qualify for tax deduction. If you specify this option, the amount specified in the POINTS= option
and the interest paid on the loan are assumed to be taxdeductible. Otherwise, it is assumed that the asset does not qualify
for tax deductions, and the cash flow is not adjusted for tax savings.

TRUEINTEREST
TI

calculates the true interest rate (effective interest rate based on the cash flow of all payments, initialization costs, discount
points, and the outstanding principal balance at the comparison period) for all the specified loans through each comparison
period. If you specify the TAXRATE= option, the true interest rate is based on aftertax cash flow. Otherwise, the beforetax
true interest rate is calculated.

NOCOMPRINT
NOCP

suppresses the printing of the loan comparison report. The NOCOMPRINT option is usually used when an OUTCOMP= data set is
created to store loan comparison information.

OUTCOMP=SASdataset

writes the loan comparison report to an output data set.
Copyright © SAS Institute Inc. All Rights Reserved.