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;
Well,
if (arrears_bal_excl_fees / bal_sasout) * 100 > 1.5 then ...;
Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.
Browse our catalog!