Also, here is some very long code that I know gives me what I need, but I am trying to condense as I have to do this for over 100 lab variables The following code gives me these variables HYDROXYPROGESTERONE_1-HYDROXYPROGESTERONE_1 where 1=normal range 0=Low and 2=high and HYDROXYPROGESTERONE_VALUE_1-HYDROXYPROGESTERONE_VALUE_7 which equal the actual numeric lab result variable. The _number at the end of the variables indicate the day-of-life at which the lab test was performed. I am trying to condense this code and I just can't figure out how to do it! IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND 106>=LAB_RESULT2=>7 and day_of_life=1 THEN HYDROXYPROGESTERONE_1=1/*NORMAL*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND 106>=LAB_RESULT2=>7 and day_of_life=2 THEN HYDROXYPROGESTERONE_2=1/*NORMAL*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND 106>=LAB_RESULT2=>7 and day_of_life=3 THEN HYDROXYPROGESTERONE_3=1/*NORMAL*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND 106>=LAB_RESULT2=>7 and day_of_life=4 THEN HYDROXYPROGESTERONE_4=1/*NORMAL*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND 106>=LAB_RESULT2=>7 and day_of_life=5 THEN HYDROXYPROGESTERONE_5=1/*NORMAL*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND 106>=LAB_RESULT2=>7 and day_of_life=6 THEN HYDROXYPROGESTERONE_6=1/*NORMAL*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND 106>=LAB_RESULT2=>7 and day_of_life>6 THEN HYDROXYPROGESTERONE_7=1/*NORMAL*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2<7 and day_of_life=1 THEN HYDROXYPROGESTERONE_1=0/*LOW*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2<7 and day_of_life=2 THEN HYDROXYPROGESTERONE_2=0/*LOW*/; IF LAB_NAMEIN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2<7 and day_of_life=3 THEN HYDROXYPROGESTERONE_3=0/*LOW*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2<7 and day_of_life=4 THEN HYDROXYPROGESTERONE_4=0/*LOW*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2<7 and day_of_life=5 THEN HYDROXYPROGESTERONE_5=0/*LOW*/; IF LAB_NAMEIN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2<7 and day_of_life=6 THEN HYDROXYPROGESTERONE_6=0/*LOW*/; IF LAB_NAMEIN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2<7 and day_of_life>6 THEN HYDROXYPROGESTERONE_7=0/*LOW*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2>106 and day_of_life=1 THEN HYDROXYPROGESTERONE_1=3/*HIGH*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2>106 and day_of_life=2 THEN HYDROXYPROGESTERONE_2=3/*HIGH*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2>106 and day_of_life=3 THEN HYDROXYPROGESTERONE_3=3/*HIGH*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2>106 and day_of_life=4 THEN HYDROXYPROGESTERONE_4=3/*HIGH*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2>106 and day_of_life=5 THEN HYDROXYPROGESTERONE_5=3/*HIGH*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2>106 and day_of_life=6 THEN HYDROXYPROGESTERONE_6=3/*HIGH*/; IF LAB_NAME IN ('17-HYDROXYPROGESTERONE') AND LAB_RESULT2>106 and day_of_life>6 THEN HYDROXYPROGESTERONE_7=3/*HIGH*/; if HYDROXYPROGESTERONE_1 in (0,1,2) then HYDROXYPROGESTERONE_VALUE_1=lab_result2; if HYDROXYPROGESTERONE_1 in (0,1,2) then HYDROXYPROGESTERONE_VALUE_2=lab_result2; if HYDROXYPROGESTERONE_1 in (0,1,2) then HYDROXYPROGESTERONE_VALUE_3=lab_result2; if HYDROXYPROGESTERONE_1 in (0,1,2) then HYDROXYPROGESTERONE_VALUE_4=lab_result2; if HYDROXYPROGESTERONE_1 in (0,1,2) then HYDROXYPROGESTERONE_VALUE_5=lab_result2; if HYDROXYPROGESTERONE_1 in (0,1,2) then HYDROXYPROGESTERONE_VALUE_6=lab_result2; if HYDROXYPROGESTERONE_1 in (0,1,2) then HYDROXYPROGESTERONE_VALUE_7=lab_result2;
... View more
