I have a data like this data x; input amt1 amt2; datalines; 100.00 6000.10 60.00 60000.01 6000.00 60.00 60.00 600.00 60.00 1000.00 14.00 14500.00 -10.00 -1000000.00 15001 15.001 15.001 15001 ; run; I would like to have it flagged as below amt1 amt2 amt flag 100 6000.1 60 . 60 60000.01 1000 1 6000 60 100 1 60 600 10 1 60 1000 16.66667 . 14 14500 1035.714 . -10 -1000000 100000 1 15001 15.001 1000.067 1 15.001 15001 1000.067 1 this is the bit of code i have written but is not solving the purpose data x; set x; amt = (int(substr(amt1,1,find(amt1,"."))))/(int(substr(amt2,1,find(amt2,".")))); if amt =1 or amt = 0.1 or amt=0.01 or amt = 0.001 or amt = 0.0001 then good = 1; else good=0; run; Thanks
... View more