PROC SQL DIVISION

Reply
anonymous_user
Posts: 0

PROC SQL DIVISION

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;

Super User
Posts: 9,878

Re: PROC SQL DIVISION

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

Ask a Question
Discussion stats
  • 1 reply
  • 1645 views
  • 0 likes
  • 2 in conversation