Yes, I also found the same. But probability of default is not calculated depend on customer number. So there might be some other calculation is there for the Y1_PD
... View more
I want to read the dataset and assign the value correcsponding variable number. How can i solve it? Thanks. data have; input number v1 v2 v3 v4 v5; datalines; 1 23 34 45 56 67 5 12 33 44 55 66 ; run; i want the output like: Accoding to number value it should read the corresponding variabe value into Final variable Number V1 V2 V3 V4 V5 Final 1 23 34 45 56 67 23 5 12 33 44 55 66 66
... View more
data want(drop=new_bmi_height); set have; by subjectid date; retain bmi new_bmi_height; if first.subjectid then do; bmi=0; new_bmi_height=0; end; if missing(result_value) then do; if upper(test_name) eq 'HEIGHT' then bmi=new_bmi_height; else if upper(test_name) eq 'WEIGHT' then bmi=0; end; else do; if upper(test_name) eq 'HEIGHT' then do; bmi=/*Calculate BMI Value */; new_bmi_height=bmi; end; else if upper(test_name) eq 'WEIGHT' then bmi=result_value; end; output; run;
... View more
proc sort data=have;by loan_id;run; data want; set have; by loan_id; retain allocated unallocated; allocated=guarantee_amount; if first.loan_id then unallocated=loan_amount-allocated; else unallocated=unallocated-allocated; output; if last.loan_id then do; allocated=0;unallocated=0; end; run;
... View more
proc sql; create table want as select name,grade, count(*) as total from one group by name,grade; quit; proc transpose data=want out=result(drop=_NAME_) prefix=total_; by name; id grade; var total; run;
... View more
proc sql; select drug, count(*) from (select id,drug,count(*) as total from have group by id,drug having calculated total ge 2) group by drug; quit;
... View more
data have; input defined_period DDMMYY10.; datalines; 01/03/2017 02/03/2017 01/04/2017 02/04/2017 03/04/2017 ; run; proc print;run; data have; set have; format defined_period DDMMYY10.; month=month(defined_period); run; proc sql; select month,count(*) as total from have group by month; quit;
... View more
