Ok, this is an imported Excel file but I've put a few datalines together to give you an idea: DATALINES; gender Med_Type SLOE_1_Reg M Private Midwest(IA, IL, IN, OH, KS, MI, MN, MO, ND, SD, WI) F Public Northeast(CT, District of Columbia, DE, MA, MD, ME, NH, PA, NY, NJ, RI, VT) F Private Southeast(AL, AR, FL, CA, KY, LA, PR, MS, NC, SC, TN, VA, WV) M Public West(AK, AZ, CA, CO, ID, HI, MT, NM, NV, OK, OR, TX, UT, WA, WY) ; You are correct, I'm just trying to get those overly-descriptive cells down to the basic single word which describes the region. Thank you all for your time and efforts!
... View more