I am relatively new to SAS and have no background in programming at all, but I have recently encountered a problem that even my PhD supervisors are stumped by. I conduced a survey on dairy cow management last year and many of the questions were checkboxes. The data came out to be a series of columns with either a number or a zero in each column; corresponding to a checked or unchecked answer for that particular aspect of the question. For example, this particularly problematic checkbox question pertains to pre-milking practices on dairy farms with 11 possible answers. I now want to make a new column (PREMILK) with all applicable checkbox answers in one column (i.e. any combination of ten PreMilk_X answers are possible; one answer (PreMilk_None) pertains to doing nothing so all other columns should be ‘0’), but it just won’t work.
Based on what I’ve read, I should not be overwhelming SAS with the amount of code. If I start with the “if everything equals 0 bar this one thing, call it ‘x'”, it refuses to compute any of the possible combinations. If I start with the combinations, it only names them with two characters (i.e. if a ‘4’ and a ‘6’ and a ‘7’ are checked, I try to rename it ‘467’ but only ’46’ is present in the new column). I need this column for univariate anaylsis for a mixed model using PROC MIXED.
I am not getting any errors; only the R matrix omitting observations warning. I’ll insert my code below. It looks horrendous, but it’s basically specifying that if x equals a check and y does not, the PREMILK column should distinguish this from a situation where x equals a check and y also equals a check.
Any help is appreciated!
/* PREMILK MONSTER */
DATA CSVMOSURVEYM0; SET CSVMOSURVEYM;
IF PreMilk_None=’1′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’0′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’1′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’2′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’4′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’3′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’4′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’6′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’5′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’6′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’8′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’7′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’9′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’8′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’9′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’10’; run;
/DRYWIPE/
DATA CSVMOSURVEYM1; SET CSVMOSURVEYM;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’12’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’124′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’6′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’1245′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’6′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’12459′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’6′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’124510′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’1246′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’12469′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’124610′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’1249′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’12410′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’6′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’125′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’6′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’1256′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’6′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’1259′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’6′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’12510′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’6′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’12569′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’6′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’125610′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’126′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’1269′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’12610′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’129′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’1210′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’4′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’13’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’4′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’134′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’4′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’136′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’4′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’1369′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’4′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’13610′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’4′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’139′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’4′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’1310′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’14’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’146′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’1469′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’14610′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’149′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’1410′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’6′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’15’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’6′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’159′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’6′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’1510′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’16’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’169′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’1610′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’19’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’2′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’110′; RUN;
/HOSE/
DATA CSVMOSURVEYM2; SET CSVMOSURVEYM1;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’24’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’246′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’2469′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’24610′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’249′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’2410′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’6′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’25’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’6′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’259′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’26’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’2610′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’29’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’3′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’210′; run;
/PREDIP/
DATA CSVMOSURVEYM3; SET CSVMOSURVEYM2;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’4′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’34’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’4′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’36’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’4′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’3610′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’4′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’8′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’37’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’4′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’8′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’3710′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’4′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’39’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’4′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’310′; run;
/PRESPRAY/
DATA CSVMOSURVEYM4; SET CSVMOSURVEYM3;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’6′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’45’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’46’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’469′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’4610′;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’8′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’47’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’49’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’5′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’410′; run;
/INDWASH/
DATA CSVMOSURVEYM5; SET CSVMOSURVEYM4;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’6′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’59’;
/COMMWASH/
DATA CSVMOSURVEYM6; SET CSVMOSURVEYM5;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’10’ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’69’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’7′ AND PreMilk_PreWashCup=’0′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’610′; run;
/WASHCUP/
DATA CSVMOSURVEYM7; SET CSVMOSURVEYM6;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’8′ AND PreMilk_Brush=’9′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’0′ THEN PREMILK=’78’;
IF PreMilk_None=’0′ AND PreMilk_DryWipe=’0′ AND PreMilk_Hose=’0′ AND PreMilk_PreDip=’0′ AND PreMilk_PreSpray=’0′ AND PreMilk_IndClothWash =’0′ AND PreMilk_CommClothWash=’0′ AND PreMilk_PreWashCup=’8′ AND PreMilk_Brush=’0′ AND PreMilk_IndClothDry=’0′ AND PreMilk_CommClothDry=’11’ THEN PREMILK=’710′; run;
AliUiC is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.