This is a partial code of the one I am working on. the purpose is to change "-0.0" or "-0" to "0". I used "case" to create a new variable "New_min" and apply it to the next new variable "m". but I failed, can anyone tell me how to do it ? Thanks. The SAS version I am working on is 9.4. proc sql noprint; create table data2 as select avisitn, case when abs(var_min) le 0.0000001 or var_min = -0 then 0 when var_min = . then . else strip(put( var_min, 10.2 )) end as new_min, strip(put(round(new_min,0.01),best.))||', '|| strip(put(round(_max,0.01),best.)) end as m from data1; quit;
... View more