Dear SAS users, Could you please help me how to optimize or to paraphrase this code into more elegant. I make some code using CATX function. The goal is i want to have three different option in result variable. Thanks Waldorf DATA test1; SET table_005_test_dec; KEEP aval lbnrind lbclsig test_dec; RUN; DATA test2; SET test1; IF NOT MISSING(aval) AND CMISS(lbnrind,lbclsig) = 0 THEN DO; result = CATX(' ', PUT(ROUND(aval, test_dec), best.), '('!!STRIP(SUBSTR(lbnrind, 1, 1))!!')', '('!!STRIP(lbclsig)!!')'); END; IF NOT MISSING(aval) AND CMISS(lbclsig) = 0 AND CMISS(lbnrind) = 1 THEN DO; result = CATX(' ', PUT(ROUND(aval, test_dec), best.), '('!!STRIP(lbclsig)!!')'); END; IF NOT MISSING(aval) AND CMISS(lbclsig) = 1 AND CMISS(lbnrind) = 0 THEN DO; result = CATX(' ', PUT(ROUND(aval, test_dec), best.), '('!!STRIP(SUBSTR(lbnrind, 1, 1))!!')'); END; RUN;
... View more