recode county (1=2) (2=3) (3=1) (4=3) (5=1) (6=1) (7=6 ) (8=7 ) (9=4) (10=4) (11=1) (12=1) (13=3) (14=1) (15=7) (16=6) (17=2) (18=3) (19=5) (20=1) (21=7) (22=1) (23=3) (24=4) (25=6) (26=4) (27=7) (28=7) (29=2) (30=2) (31=6) (32=5) (33=6) (34=2) (35=5) (36=3) (37=7) (38=1) (39= 5) (40=6) (41=2) (42=7) (43=5) (44=1) (45=1) (46=7) (47=4) (48=6) (49=3) (50=1) (51=5) (52=6) (53=5) (54=6) (55=3) (56=1) (57=1) (58=7) (59=1) (60=3) (61=1) (62=2) (63=5) (64=6) (65=4) (66=7) (67=6) (68=5) (69=6) (70=7) (71=4) (72=7) (73=5) (74=6) (75=1) (76=2) (77=4) (78=4) (79=2) (80=3) (81=1) (82=4) (83=3) (84=3) (85=2) (86=2) (87=1) (88=1) (89=7) (90=3) (91=5) (92=5) (93=5) (94=7) (95=1) (96=6) (97=1) (98=6) (99=2) (100=1) (101=1) (miss=.), gen(region)

label variable region "Region"

label define counties 1	"Alamance" 2 "Alexander" 3 "Alleghany" 4 "Anson" 5 "Ashe" 6 "Avery" 7 "Beaufort"8 "Bertie" 9 "Bladen" 10 "Brunswick" 11 "Buncombe" 12 "Burke" 13 "Cabarrus" 14	"Caldwell" 15 "Camden" 16 "Carteret" 17	"Caswell" 18 "Catawba"19 "Chatham"20 "Cherokee" 21 "Chowan" 22 "Clay" 23 "Cleveland"24 "Columbus" 25 "Craven" 26 "Cumberland" 27 "Currituck" 28 "Dare" 29 "Davidson" 30 "Davie" 31 "Duplin" 32 "Durham" 33 "Edgecombe" 34 "Forsyth" 35 "Franklin" 36 "Gaston" 37 "Gates" 38 "Graham" 39 "Granville"40 "Greene" 41 "Guilford" 42 "Halifax" 43 "Harnett" 44 "Haywood" 45 "Henderson" 46 "Hertford" 47 "Hoke" 48 "Hyde" 49 "Iredell" 50 "Jackson" 51 "Johnston" 52 "Jones" 53 "Lee" 54 "Lenoir" 55	"Lincoln" 56 "Macon" 57 "Madison" 58 "Martin" 59 "McDowell" 60 "Mecklenburg" 61 "Mitchell" 62 "Montgomery" 63 "Moore" 64 "Nash" 65 "New Hanover" 66 "Northampton" 67 "Onslow" 68 "Orange" 69 "Pamlico" 70 "Pasquotank" 71 "Pender" 72 "Perquimans" 73 "Person" 74 "Pitt" 75 "Polk" 76 "Randolph" 77 "Richmond" 78 "Robeson" 79 "Rockingham" 80 "Rowan" 81 "Rutherford" 82 "Sampson" 83 "Scotland" 84 "Stanly" 85 "Stokes" 86 "Surry" 87 "Swain" 88 "Transylvania" 89 "Tyrrell" 90 "Union" 91 "Vance" 92 "Wake" 93 "Warren" 94 "Washington" 95 "Watauga" 96 "Wayne" 97 "Wilkes" 98 "Wilson" 99 "Yadkin" 100 "Yancey" 

label values county counties

label define regions 1 "Advantage West" 2 "Piedmont Triad" 3 "Charlotte" 4 "Southeast" 5 "Research Triangle" 6 "Eastern" 7 "Northeast"

label values region regions