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;
It looks like you don't need Calculated any more . since it is used to refer to a new calculated variable .
and also could try function DIVIDE(balance,val)
distinct month_date,
balance_outstanding as balance,
curr_index_val as val,
calculated balance/calculated val as dtv
Xia Keshan
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.