/*--------------------------------------------
Generating DCL Loss Groups
--------------------------------------------*/
* Agricultural Region Feeders
if reg_composite == "AGD" {
	if inlist(month, "201210", "201211", "201212", "201301") {		//pre-policy change
		replace DCLGroup_own = "A" 	if (LOSS_ALL < 21)
		replace DCLGroup_own = "B" 	if (LOSS_ALL >= 21 & LOSS_ALL < 29)
		replace DCLGroup_own = "C" 	if (LOSS_ALL >= 29 & LOSS_ALL < 37)
		replace DCLGroup_own = "D" 	if (LOSS_ALL >= 37 & LOSS_ALL < 45)
		replace DCLGroup_own = "E" 	if (LOSS_ALL >= 45 & LOSS_ALL < 53)
		replace DCLGroup_own = "F" 	if (LOSS_ALL >= 53 & LOSS_ALL < 58)
		replace DCLGroup_own = "G1" if (LOSS_ALL >= 58 & LOSS_ALL < 63)
		replace DCLGroup_own = "G2" if (LOSS_ALL >= 63 & LOSS_ALL < 68)
		replace DCLGroup_own = "G3" if (LOSS_ALL >= 68 & LOSS_ALL <= 100)
	}
//	else if ((year != "2012") & (month != "201301")) {				//post-policy change
	else if !inlist(month, "201210", "201211", "201212", "201301") {
		replace DCLGroup_own = "A" 	if (LOSS_ALL < 21)
		replace DCLGroup_own = "B" 	if (LOSS_ALL >= 21 & LOSS_ALL < 29)
		replace DCLGroup_own = "C" 	if (LOSS_ALL >= 29 & LOSS_ALL < 37)
		replace DCLGroup_own = "D" 	if (LOSS_ALL >= 37 & LOSS_ALL < 45)
		replace DCLGroup_own = "E" 	if (LOSS_ALL >= 45 & LOSS_ALL < 53)
		replace DCLGroup_own = "F" 	if (LOSS_ALL >= 53 & LOSS_ALL < 61)
		replace DCLGroup_own = "G1" if (LOSS_ALL >= 61 & LOSS_ALL < 68)
		replace DCLGroup_own = "G2" if (LOSS_ALL >= 68 & LOSS_ALL < 76)
		replace DCLGroup_own = "G3" if (LOSS_ALL >= 76 & LOSS_ALL <= 100)
	}
}
* "Other" Region Feeders
else if reg_composite == "OTH" {
	if inlist(month, "201210", "201211", "201212", "201301") {		//pre-policy change
		replace DCLGroup_own = "A" 	if (LOSS_ALL < 18)
		replace DCLGroup_own = "B" 	if (LOSS_ALL >= 18 & LOSS_ALL < 26)
		replace DCLGroup_own = "C" 	if (LOSS_ALL >= 26 & LOSS_ALL < 34)
		replace DCLGroup_own = "D" 	if (LOSS_ALL >= 34 & LOSS_ALL < 42)
		replace DCLGroup_own = "E" 	if (LOSS_ALL >= 42 & LOSS_ALL < 50)
		replace DCLGroup_own = "F" 	if (LOSS_ALL >= 50 & LOSS_ALL < 55)
		replace DCLGroup_own = "G1" if (LOSS_ALL >= 55 & LOSS_ALL < 60)
		replace DCLGroup_own = "G2" if (LOSS_ALL >= 60 & LOSS_ALL < 65)
		replace DCLGroup_own = "G3" if (LOSS_ALL >= 65 & LOSS_ALL <= 100)
	}
	else if ((year != "2012") & (month != "201301")) {				//post-policy change
		replace DCLGroup_own = "A" 	if (LOSS_ALL < 18)
		replace DCLGroup_own = "B" 	if (LOSS_ALL >= 18 & LOSS_ALL < 26)
		replace DCLGroup_own = "C" 	if (LOSS_ALL >= 26 & LOSS_ALL < 34)
		replace DCLGroup_own = "D" 	if (LOSS_ALL >= 34 & LOSS_ALL < 42)
		replace DCLGroup_own = "E" 	if (LOSS_ALL >= 42 & LOSS_ALL < 50)
		replace DCLGroup_own = "F" 	if (LOSS_ALL >= 50 & LOSS_ALL < 58)
		replace DCLGroup_own = "G1" if (LOSS_ALL >= 58 & LOSS_ALL < 66)
		replace DCLGroup_own = "G2" if (LOSS_ALL >= 66 & LOSS_ALL < 74)
		replace DCLGroup_own = "G3" if (LOSS_ALL >= 74 & LOSS_ALL <= 100)
	}
}

* Generate a "wrong DCL Group" variable that is based on
novarabbrev {
if Region == "AGD" {
	if inlist(month, "201210", "201211", "201212", "201301") {		//pre-policy change
		replace DCLGroup_wrong = "A" 	if (LOSS_ALL < 21)
		replace DCLGroup_wrong = "B" 	if (LOSS_ALL >= 21 & LOSS_ALL < 29)
		replace DCLGroup_wrong = "C" 	if (LOSS_ALL >= 29 & LOSS_ALL < 37)
		replace DCLGroup_wrong = "D" 	if (LOSS_ALL >= 37 & LOSS_ALL < 45)
		replace DCLGroup_wrong = "E" 	if (LOSS_ALL >= 45 & LOSS_ALL < 53)
		replace DCLGroup_wrong = "F" 	if (LOSS_ALL >= 53 & LOSS_ALL < 58)
		replace DCLGroup_wrong = "G1" if (LOSS_ALL >= 58 & LOSS_ALL < 63)
		replace DCLGroup_wrong = "G2" if (LOSS_ALL >= 63 & LOSS_ALL < 68)
		replace DCLGroup_wrong = "G3" if (LOSS_ALL >= 68 & LOSS_ALL <= 100)
	}
	else if ((year != "2012") & (month != "201301")) {				//post-policy change
		replace DCLGroup_wrong = "A" 	if (LOSS_ALL < 21)
		replace DCLGroup_wrong = "B" 	if (LOSS_ALL >= 21 & LOSS_ALL < 29)
		replace DCLGroup_wrong = "C" 	if (LOSS_ALL >= 29 & LOSS_ALL < 37)
		replace DCLGroup_wrong = "D" 	if (LOSS_ALL >= 37 & LOSS_ALL < 45)
		replace DCLGroup_wrong = "E" 	if (LOSS_ALL >= 45 & LOSS_ALL < 53)
		replace DCLGroup_wrong = "F" 	if (LOSS_ALL >= 53 & LOSS_ALL < 61)
		replace DCLGroup_wrong = "G1" if (LOSS_ALL >= 61 & LOSS_ALL < 68)
		replace DCLGroup_wrong = "G2" if (LOSS_ALL >= 68 & LOSS_ALL < 76)
		replace DCLGroup_wrong = "G3" if (LOSS_ALL >= 76 & LOSS_ALL <= 100)
	}
}
* "Other" Region Feeders
else if Region == "OTH" {
	if inlist(month, "201210", "201211", "201212", "201301") {		//pre-policy change
		replace DCLGroup_wrong = "A" 	if (LOSS_ALL < 18)
		replace DCLGroup_wrong = "B" 	if (LOSS_ALL >= 18 & LOSS_ALL < 26)
		replace DCLGroup_wrong = "C" 	if (LOSS_ALL >= 26 & LOSS_ALL < 34)
		replace DCLGroup_wrong = "D" 	if (LOSS_ALL >= 34 & LOSS_ALL < 42)
		replace DCLGroup_wrong = "E" 	if (LOSS_ALL >= 42 & LOSS_ALL < 50)
		replace DCLGroup_wrong = "F" 	if (LOSS_ALL >= 50 & LOSS_ALL < 55)
		replace DCLGroup_wrong = "G1" if (LOSS_ALL >= 55 & LOSS_ALL < 60)
		replace DCLGroup_wrong = "G2" if (LOSS_ALL >= 60 & LOSS_ALL < 65)
		replace DCLGroup_wrong = "G3" if (LOSS_ALL >= 65 & LOSS_ALL <= 100)
	}
	else if ((year != "2012") & (month != "201301")) {				//post-policy change
		replace DCLGroup_wrong = "A" 	if (LOSS_ALL < 18)
		replace DCLGroup_wrong = "B" 	if (LOSS_ALL >= 18 & LOSS_ALL < 26)
		replace DCLGroup_wrong = "C" 	if (LOSS_ALL >= 26 & LOSS_ALL < 34)
		replace DCLGroup_wrong = "D" 	if (LOSS_ALL >= 34 & LOSS_ALL < 42)
		replace DCLGroup_wrong = "E" 	if (LOSS_ALL >= 42 & LOSS_ALL < 50)
		replace DCLGroup_wrong = "F" 	if (LOSS_ALL >= 50 & LOSS_ALL < 58)
		replace DCLGroup_wrong = "G1" if (LOSS_ALL >= 58 & LOSS_ALL < 66)
		replace DCLGroup_wrong = "G2" if (LOSS_ALL >= 66 & LOSS_ALL < 74)
		replace DCLGroup_wrong = "G3" if (LOSS_ALL >= 74 & LOSS_ALL <= 100)
	}
}
}