Quick follow up, along with arv1_d1, i also have arv1_d2 and arv1_d3. Is there a way to make this same condition apply to arv1_d2 and arv1_d3 etc?
Below is the long way but is there a shorter way?
ELSE IF arv1_d1 in (3,4,5,11,14,42,44,45) then arvtype = 2;
ELSE IF arv1_d2 in (3,4,5,11,14,42,44,45) then arvtype = 2;
ELSE IF arv1_d3 in (3,4,5,11,14,42,44,45) then arvtype = 2;
ELSE IF arv2_d1 in (3,4,5,11,14,42,44,45) then arvtype = 2;