Im looking to divide balance by valuation to get an output as dtv.
I have added the calculation in and works if I 'sum' the balance and index valuation but as soon as I take this out I error.
ERROR: It appears that the CALCULATED variable balance was referenced before it was defined.
ERROR: The following columns were not found as CALCULATED references in the immediate query:
balance, val.
I need to do this in stages as this part of my code without the sum will get me the individual account LTV, I then want to group the individual dtv into segments below. Unsure if I can do this in one statement with a CASE statement?
| Less than 30% |
| 30 to 50% |
| 50 to 60% |
| 60-75% |
| 75 to 95% |
| 95-100% |
| 100%+ |
proc sql;
create table work.dtv1 as
select
distinct month_date,
balance_outstanding as balance,
curr_index_val as val,
calculated balance/calculated val as dtv
from
gbasel.baseljul14
where optimum_platform = 'Optimum'
and Arrears_lit_stage_code not in ('L4','L5','L6')
order by month_date;
quit;
