Yes, it is an if-then statement. I did not provide the whole. It starts from dx to dx18, so it was not the whole code. I am testing the logic, which simply is if step a = 1 and step c= 1, then column CO_fire(CD) should be flagged as 1 and not missing as shown in the picture. ~= mean NE, the three conditions are fire-incident, non-fire, and Unknown. It seems like it works for non-fire, so I do not know why it would not work for fire incidents. The code was very long below is just step A * sub-step A;
if substr(dx,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx1,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx1,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx2,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx2,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx3,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx3,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx4,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx4,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx5,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx5,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx6,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx6,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx7,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx7,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx8,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx8,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx9,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx9,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx10,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx10,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx11,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx11,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx12,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx12,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx13,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx13,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx14,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx14,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx15,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx15,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx16,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx16,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx17,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx16,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') or
substr(dx18,1,5) in ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894') or substr(dx17,1,6) in ('T582X1', 'T582X4', 'T588X1', 'T588X4') then COyes_step2a10 = 1;
... View more