Advertisement
Guest User

Untitled

a guest
Aug 27th, 2015
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.39 KB | None | 0 0
  1. utility_name state county unique_id
  2. Alaska Village Elec Coop, Inc AK Borough, Kodiak Island 221AK
  3. Wolverine Pwr Supply Coop, Inc MI Allegan, Antim, Barry, Benzie, 20910MI
  4. Wolverine Pwr Supply Coop, Inc MI Clinton, Eaton, Emmet, Gratiot 20910MI
  5. Wolverine Pwr Supply Coop, Inc MI Grand Traverse, Ingham, Ionia 20910MI
  6. Wolverine Pwr Supply Coop, Inc MI Isabella, Lake, Leelanau 20910MI
  7. Wolverine Pwr Supply Coop, Inc MI Manistee, Mason, Mecosta, 20910MI
  8. Wolverine Pwr Supply Coop, Inc MI Missaukee, Montcalm, Muskegon 20910MI
  9. Wolverine Pwr Supply Coop, Inc MI Newaygo, Oceana, Osceola 20910MI
  10. Wolverine Pwr Supply Coop, Inc MI Ottawa, Alpena, Charlevoix 20910MI
  11. Soyland Power Coop Inc IL McDonough, McCoupin 40307IL
  12. Soyland Power Coop Inc IL Menard, Morgan,Montgomery 40307IL
  13. Soyland Power Coop Inc IL Sangamon,Schuyler,Scott,Pike 40307IL
  14.  
  15. Alaska Village Elec Coop, Inc AK Borough 221AK
  16. Alaska Village Elec Coop, Inc AK Kodiak Island 221AK
  17.  
  18. gen long id = _n
  19. gen ncounties = length(county) - length(subinstr(county, ",", "", .)) + 1
  20. expand ncounties
  21. bysort id : gen id2 = _n
  22. su ncounties, meanonly
  23. gen county2 = ""
  24. forval j = 1/`r(max)' {
  25. replace county2 = county`j' if id2 == `j'
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement