Hi All, So I am running into a big of a snag, I am using the following code to create a new variable for data mapping purposes: data txttest1; set work.ptxt; if find(tx, 'mg', "i")>0 then P2_PR_Dose_Units=01; else if find(tx, 'g', "i", "-1")=1 and find(tx, 'mg', "i")=0 then P2_PR_Dose_Units=02; else if find(tx, 'unit', "i")>0 then P2_PR_Dose_Units=03; run; So, my 1s and 3s are coming up okay, but all 2s are coming up as missing variables. Basically, I am trying to count from right to left and if the first letter is a g but does not contain mg then it should be a 2, if there is a g after the first position from right to left then it needs to be either a 1 o a 3 depending on the category. I am mainly having issues getting the start position to work.
... View more