Hi There, I'm trying to calculate the default value from the available data. I have merged the data by using following code Data Loan_1; Set 36_Months 60 Months; Run; Then I have sorted the data using proc sort After that i have created a variable named Loan_Status2 in which I have created to values 1st is Current and 2nd is default using following code Data Loan_11; Set Loan_1; If loan_Status = 'Late (31-120 Days)' or Loan_Status = 'Default' then Loan_Status2 = 1; Else If loan_Status = 'Current' or loan_Status = 'Late (16-30 Days)' or loan_Status = 'In Grace Period' or loan_Status = 'Charged Off' or loan_Status = 'Fully Paid' then loan_Status2 = 0; After this I'm trying to calculate the default % by using following code Data Loan_111; Set Loan_11; DefaultLoan = (Sum (1)/Sum(Loan_Status2)); Format DefaultLoan $Char20.; Proc Print; Run; But getting wrong output please do the needful. Regards, Roshan Malewar
... View more