Hi @PaigeMiller, I was trying the below, but haven't succeeded. Trying different combinations like splitting the numbers and then performing a check PROC SQL; CREATE TABLE data.new_dataset AS SELECT t1.*, CASE WHEN substr(scan(put(my_number,best32.),2,"."),1,1) = '0' AND .... THEN ... WHEN LTV_New > 999.9 THEN 999.9 ELSE round(LTV_New, 0.01) END AS new_num FROM data.my_data t1; QUIT;
... View more