Hi, please try the below code , However i agree with Art , if you provide more details then you will get the more appropriate response. i just tried with a simple if then statement. Hope this helps. data want; set have; if OnPromotion='N' and JanuaryEstimate eq . then JanuaryEstimate=_6mAvg; run; Thanks, Jag ... View more

Try: Data Have;   Input CustCode V1082 V1152 V1154 V1177 V1178;   Datalines; 31 . . . -260 . 190 . . . 210 -2656 228 . . . 137 . 372 . -782 . -945 . 451 . . . -153 . 590 . -851 -286 -403 -110 623 . . -280 -4335 . 649 . . . -355 . 670 . . -107 -2062 -2705 692 . -403 -373 -1312 . 767 . . . -858 . 778 . -394 -671 . . 800 -8 2 42 122 -1393 832 . . -651 -1071 . 876 . . . 80 . 899 . . 10 1 6 ; Run; Proc SQL;   Create Table Want As Select * From Have   Where (Case When V1082 between -10 and 10 OR                    V1152 between -10 and 10 OR              V1154 between -10 and 10 OR              V1177 between -10 and 10 OR              V1178 between -10 and 10 Then 1         Else 0 End)=1; Quit; ... View more