The final statement im trying to add 'Age' plus 'Year but It doesnt work, I just get a a full stop, anyone know why my code wont add the 2 variable, both numeric?
I have had to create 'Customer age profile' to obtain the 'Age' and a second statement 'Term years to get the 'Year'. Im then joining the 2 tables to create the third statement 'Add age and year'.
/*Customer Age Profile*/
proc sql;
create table work.borrower_age as
select
AccountNo as accnum,
int(yrdif(DATE_OF_BIRTH,today(),'ACTUAL')) as Age
from
green.optimum201302;
quit;
/*Term Years*/
proc sql;
create table work.term_years as
select
distinct month_date,
accnum,
round(remaining_term_months/12,1) as year
from work.dataset_basel;
quit;
/*Add Age and Year*/
proc sql;
create table work.age_at_term as
select
b.month_date,
a.accnum,
a.age + b.year as age_term
from
work.borrower_age as a
left join work.term_years as b
on a.accnum = b.accnum;
quit;
