PROC SQL DIVISION

[This widget could not be displayed.]

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;

[Ksharp]

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