Calculate a % of a Balance

anonymous_user — Fri, 21 Oct 2016 08:41:04 GMT

Hi,

I need to calculate mortgages that are in arrears (arrears_bal_excl_fees) by 1.5% or more than the outstanding balance (bal_sasout).

How do I go about doing this please?

data mortgage_arrs;
set mortbib.mortgage_&curr_month. (Keep= arrears_bal_excl_fees monthly_pmt bal_sasout);
run;

Re: Calculate a % of a Balance

RW9 — Fri, 21 Oct 2016 09:05:54 GMT

Well,

if (arrears_bal_excl_fees / bal_sasout) * 100 > 1.5 then ...;