Thanks but i dont have the bins in the above format. What i have is: *------------------------------------------------------------*; * Variable: LoanToValue; *------------------------------------------------------------*; if MISSING(LoanToValue) then do; SCORECARD_POINTS = SCORECARD_POINTS + 21; SCR_LoanToValue= 21; end; else if LoanToValue < 0 then do; SCORECARD_POINTS = SCORECARD_POINTS + 21; SCR_LoanToValue= 21; end; else if NOT MISSING(LoanToValue) and 0 <= LoanToValue AND LoanToValue < 0.51 then do; SCORECARD_POINTS = SCORECARD_POINTS + 70; SCR_LoanToValue = 70; end; else if NOT MISSING(LoanToValue) and 0.51 <= LoanToValue AND LoanToValue < 0.67 then do; SCORECARD_POINTS = SCORECARD_POINTS + 55; SCR_LoanToValue = 55; end; else if NOT MISSING(LoanToValue) and 0.67 <= LoanToValue AND LoanToValue < 0.81 then do; SCORECARD_POINTS = SCORECARD_POINTS + 38; SCR_LoanToValue = 38; end; else if NOT MISSING(LoanToValue) and 0.81 <= LoanToValue then do; SCORECARD_POINTS = SCORECARD_POINTS + 21; SCR_LoanToValue = 21; end; Currently, I am manually putting these statements in the above format, My ques is, can i generate a code that will give the output in the given format: Value B_LOANTOVALUE . = "Missing" low-<0 = "low-<0" 0-<0.51 = "0-<0.51" 0.51-<0.67 = "0.51-<0.67" 0.67-<0.81 = "0.67-<0.81" 0.81-high = "0.81-high";
... View more