[HELP] Reshaping Data

[Rafael Rodriguez]

Hello Statalist--- I have a dataset which I want to end up looking like this: With county names listed more than once and with each year and month repeating for the corresponding observation.

* Example generated by -dataex-. To install: ssc install dataex
clear
input str15 county_name long medicaid_enroll int year byte month
"01-ADAMS       "   4541 2016 1
"02-ALLEN       "  77671 2016 1
"03-BARTHOLOMEW "  12834 2016 1
"04-BENTON      "   1903 2016 1
"05-BLACKFORD   "   3140 2016 1
"06-BOONE       "   6411 2016 1
"07-BROWN       "   2590 2016 1
"08-CARROLL     "   3010 2016 1
"09-CASS        "   8654 2016 1
"10-CLARK       "  21093 2016 1
"11-CLAY        "   6268 2016 1
"12-CLINTON     "   7483 2016 1
"13-CRAWFORD    "   2524 2016 1
"14-DAVIESS     "   6307 2016 1
"15-DEARBORN    "   7647 2016 1
"16-DECATUR     "   4938 2016 1
"17-DEKALB      "   7089 2016 1
"18-DELAWARE    "  26611 2016 1
"19-DUBOIS      "   5111 2016 1
"20-ELKHART     "  40855 2016 1
"21-FAYETTE     "   7288 2016 1
"22-FLOYD       "  13070 2016 1
"23-FOUNTAIN    "   3399 2016 1
"24-FRANKLIN    "   3919 2016 1
"25-FULTON      "   4420 2016 1
"26-GIBSON      "   5709 2016 1
"27-GRANT       "  17591 2016 1
"28-GREENE      "   7275 2016 1
"29-HAMILTON    "  22670 2016 1
"30-HANCOCK     "   9164 2016 1
"31-HARRISON    "   6631 2016 1
"32-HENDRICKS   "  15335 2016 1
"33-HENRY       "  11162 2016 1
"34-HOWARD      "  19020 2016 1
"35-HUNTINGTON  "   6526 2016 1
"36-JACKSON     "   8578 2016 1
"37-JASPER      "   5685 2016 1
"38-JAY         "   4550 2016 1
"39-JEFFERSON   "   6667 2016 1
"40-JENNINGS    "   6733 2016 1
"41-JOHNSON     "  22208 2016 1
"42-KNOX        "   8490 2016 1
"43-KOSCIUSKO   "  12875 2016 1
"44-LAGRANGE    "   3884 2016 1
"45-LAKE        " 118245 2016 1
"46-LAPORTE     "  25976 2016 1
"47-LAWRENCE    "  10079 2016 1
"48-MADISON     "  32683 2016 1
"49-MARION      " 278933 2016 1
"50-MARSHALL    "   8383 2016 1
"51-MARTIN      "   2096 2016 1
"52-MIAMI       "   7901 2016 1
"53-MONROE      "  19697 2016 1
"54-MONTGOMERY  "   7165 2016 1
"55-MORGAN      "  13101 2016 1
"56-NEWTON      "   2882 2016 1
"57-NOBLE       "   8423 2016 1
"58-OHIO        "    787 2016 1
"59-ORANGE      "   5187 2016 1
"60-OWEN        "   5092 2016 1
"61-PARKE       "   3285 2016 1
"62-PERRY       "   3266 2016 1
"63-PIKE        "   2410 2016 1
"64-PORTER      "  23628 2016 1
"65-POSEY       "   3608 2016 1
"66-PULASKI     "   2719 2016 1
"67-PUTNAM      "   6190 2016 1
"68-RANDOLPH    "   5859 2016 1
"69-RIPLEY      "   4888 2016 1
"70-RUSH        "   3461 2016 1
"71-ST. JOSEPH  "  57969 2016 1
"72-SCOTT       "   6700 2016 1
"73-SHELBY      "   8934 2016 1
"74-SPENCER     "   3069 2016 1
"75-STARKE      "   6075 2016 1
"76-STEUBEN     "   5436 2016 1
"77-SULLIVAN    "   4632 2016 1
"78-SWITZERLAND "   2211 2016 1
"79-TIPPECANOE  "  28281 2016 1
"80-TIPTON      "   2271 2016 1
"81-UNION       "   1416 2016 1
"82-VANDERBURGH "  38738 2016 1
"83-VERMILLION  "   3797 2016 1
"84-VIGO        "  26543 2016 1
"85-WABASH      "   6214 2016 1
"86-WARREN      "   1381 2016 1
"87-WARRICK     "   7723 2016 1
"88-WASHINGTON  "   6498 2016 1
"89-WAYNE       "  16924 2016 1
"90-WELLS       "   4132 2016 1
"91-WHITE       "   4560 2016 1
"92-WHITLEY     "   4189 2016 1
"01-ADAMS       "   4530 2016 2
"02-ALLEN       "  78274 2016 2
"03-BARTHOLOMEW "  13051 2016 2
"04-BENTON      "   1908 2016 2
"05-BLACKFORD   "   3152 2016 2
"06-BOONE       "   6469 2016 2
"07-BROWN       "   2628 2016 2
"08-CARROLL     "   3082 2016 2
end

The dataset I have to convert to look like the one above is the following: With with neither county or date being repeated, because county is represented horizontally and date is vertical :

* Example generated by -dataex-. To install: ssc install dataex
clear
input str14 Month str4(Adams Asotin) str5(Benton Chelan) str4 Clallam str5 Clark str3 Columbia str5 Cowlitz str4(Douglas Ferry) str5 Franklin str3 Garfield str5 Grant
"FEBRUARY 2019"  "6772" "2896" "30889" "12758" "8549" "58011" "438" "16397" "7533" "949"  "22704" "284" "22341"
"JANUARY 2019"   "6759" "2935" "31019" "12785" "8607" "58183" "444" "16409" "7536" "951"  "22787" "279" "22315"
"DECEMBER 2018"  "6731" "2901" "31071" "12757" "8613" "58339" "440" "16393" "7571" "948"  "22781" "289" "22244"
"NOVEMBER 2018"  "6758" "2893" "31098" "12810" "8633" "58498" "441" "16417" "7515" "938"  "22829" "289" "22271"
"OCTOBER 2018"   "6724" "2914" "31114" "12843" "8629" "58439" "451" "16454" "7500" "940"  "22898" "286" "22335"
"SEPTEMBER 2018" "6741" "2877" "30968" "12839" "8693" "58423" "464" "16447" "7517" "937"  "22995" "282" "22316"
"AUGUST 2018"    "6744" "2882" "31039" "12865" "8634" "58548" "473" "16440" "7546" "939"  "23015" "280" "22299"
"JULY 2018"      "6786" "2866" "31089" "12830" "8652" "58617" "475" "16476" "7543" "936"  "23097" "283" "22214"
"JUNE 2018"      "6825" "2859" "31138" "12833" "8603" "58576" "476" "16447" "7530" "949"  "23022" "279" "22119"
"MAY 2018"       "6839" "2864" "31176" "12872" "8662" "58851" "480" "16445" "7544" "964"  "23017" "284" "22161"
"APRIL 2018"     "6834" "2877" "31151" "12861" "8641" "58846" "482" "16501" "7509" "962"  "22914" "286" "22063"
"MARCH 2018"     "6851" "2893" "31304" "12901" "8711" "59199" "471" "16557" "7520" "957"  "22970" "295" "22099"
"FEBRUARY 2018"  "6850" "2914" "31340" "12962" "8707" "59342" "477" "16552" "7529" "948"  "22944" "305" "22108"
"JANUARY 2018"   "6840" "2895" "31324" "12972" "8733" "59487" "481" "16530" "7582" "952"  "22983" "300" "22050"
"DECEMBER 2017"  "6782" "2868" "31264" "13059" "8715" "59509" "482" "16504" "7578" "946"  "23091" "307" "21989"
"NOVEMBER 2017"  "6761" "2867" "31180" "13092" "8666" "59320" "478" "16456" "7590" "937"  "23084" "295" "21976"
"OCTOBER 2017"   "6792" "2850" "31130" "13141" "8657" "59314" "484" "16389" "7614" "931"  "23130" "297" "22022"
"SEPTEMBER 2017" "6831" "2810" "31117" "13205" "8661" "59342" "481" "16311" "7584" "939"  "23064" "304" "21969"
"AUGUST 2017"    "6812" "2826" "31197" "13218" "8679" "59537" "473" "16355" "7606" "925"  "23073" "301" "21988"
"JULY 2017"      "6827" "2809" "31084" "13219" "8692" "59590" "470" "16291" "7630" "922"  "23022" "297" "22035"
"JUNE 2017"      "6814" "2837" "31111" "13274" "8738" "60000" "463" "16370" "7656" "931"  "23037" "293" "22073"
"MAY 2017"       "6804" "2837" "31061" "13265" "8726" "60118" "469" "16452" "7628" "927"  "22994" "297" "22082"
"APRIL 2017"     "6785" "2831" "31059" "13316" "8734" "60098" "471" "16476" "7615" "922"  "23047" "292" "21981"
"MARCH 2017"     "6793" "2847" "31013" "13343" "8745" "60162" "468" "16454" "7621" "935"  "23012" "297" "22003"
"FEBRUARY 2017"  "6776" "2882" "30974" "13336" "8738" "60194" "470" "16412" "7614" "938"  "22992" "295" "22024"
"JANUARY 2017"   "6788" "2887" "30987" "13319" "8761" "60307" "475" "16431" "7624" "931"  "22988" "296" "22009"
"DECEMBER 2016"  "6786" "2880" "30821" "13280" "8741" "59981" "474" "16346" "7624" "916"  "23002" "300" "21997"
"NOVEMBER 2016"  "6766" "2881" "30711" "13270" "8736" "59767" "472" "16281" "7618" "927"  "22950" "298" "21963"
"OCTOBER 2016"   "6748" "2881" "30598" "13237" "8672" "59722" "485" "16182" "7646" "916"  "22879" "295" "21985"
"SEPTEMBER 2016" "6710" "2854" "30541" "13259" "8653" "59496" "474" "16159" "7638" "912"  "22822" "297" "21886"
"AUGUST 2016"    "6665" "2850" "30448" "13242" "8623" "59221" "467" "16164" "7594" "898"  "22770" "290" "21915"
"JULY 2016"      "6671" "2847" "30230" "13241" "8615" "58932" "462" "16056" "7564" "905"  "22689" "283" "21817"
"JUNE 2016"      "6639" "2836" "30110" "13253" "8623" "58999" "461" "16045" "7569" "903"  "22697" "293" "21805"
"MAY 2016"       "6596" "2802" "29997" "13241" "8560" "58913" "452" "15970" "7569" "898"  "22693" "285" "21741"
"APRIL 2016"     "6547" "2812" "29943" "13327" "8545" "58902" "444" "15928" "7507" "887"  "22651" "289" "21741"
"MARCH 2016"     "6554" "2795" "29841" "13325" "8556" "59021" "467" "15900" "7524" "906"  "22670" "295" "21688"
"FEBRUARY 2016"  "6587" "2773" "29757" "13302" "8533" "58907" "479" "15845" "7512" "897"  "22614" "287" "21702"
"JANUARY 2016"   "6572" "2778" "29658" "13261" "8554" "58836" "481" "15796" "7501" "897"  "22615" "296" "21620"
"DECEMBER 2015"  "6595" "2776" "29612" "13257" "8519" "58630" "488" "15766" "7499" "885"  "22509" "286" "21606"
"NOVEMBER 2015"  "6566" "2762" "29437" "13193" "8499" "58248" "471" "15730" "7470" "858"  "22450" "296" "21577"
"OCTOBER 2015"   "6569" "2757" "29296" "13137" "8451" "57891" "466" "15684" "7450" "873"  "22388" "293" "21554"
"SEPTEMBER 2015" "6592" "2764" "29195" "13093" "8413" "57526" "468" "15645" "7382" "870"  "22389" "283" "21495"
"AUGUST 2015"    "6577" "2757" "28991" "12992" "8324" "57206" "463" "15437" "7342" "867"  "22270" "279" "21318"
"JULY 2015"      "6575" "2736" "28761" "12924" "8282" "56817" "454" "15342" "7320" "900"  "22187" "274" "21185"
"JUNE 2015"      "6596" "2728" "28669" "12911" "8285" "56710" "471" "15213" "7254" "894"  "22112" "268" "21088"
"MAY 2015"       "6542" "2689" "28587" "12831" "8251" "56593" "469" "15068" "7255" "891"  "22106" "272" "20950"
"APRIL 2015"     "6525" "2664" "28456" "12849" "8240" "56492" "478" "14984" "7188" "886"  "22005" "271" "20855"
"MARCH 2015"     "6484" "2680" "28377" "12785" "8197" "56309" "468" "14942" "7139" "893"  "21889" "261" "20770"
"FEBRUARY 2015"  "6453" "2664" "28227" "12760" "8126" "56185" "479" "14837" "7088" "888"  "21829" "261" "20682"
"JANUARY 2015"   "6435" "2641" "27958" "12622" "8037" "55471" "467" "14718" "7016" "879"  "21652" "266" "20534"
"DECEMBER 2014"  "6389" "2584" "27737" "12558" "7935" "54905" "462" "14566" "6974" "862"  "21482" "246" "20419"
"NOVEMBER 2014"  "6371" "2549" "27378" "12402" "7840" "54217" "452" "14372" "6976" "857"  "21358" "252" "20321"
"OCTOBER 2014"   "6388" "2558" "27199" "12407" "7791" "53874" "465" "14354" "6916" "860"  "21261" "259" "20217"
"SEPTEMBER 2014" "6374" "2521" "27059" "12353" "7775" "53488" "470" "14298" "6853" "883"  "21091" "244" "20126"
"AUGUST 2014"    "6410" "2539" "27008" "12380" "7723" "53563" "472" "14263" "6797" "873"  "20974" "244" "20092"
"JULY 2014"      "6381" "2534" "26863" "12275" "7704" "53543" "478" "14129" "6786" "888"  "20904" "247" "20012"
"JUNE 2014"      "6350" "2555" "26860" "12288" "7708" "53617" "480" "14147" "6737" "910"  "20863" "242" "19989"
"MAY 2014"       "6320" "2573" "26802" "12270" "7693" "53435" "488" "14220" "6733" "905"  "20771" "235" "19988"
"APRIL 2014"     "6331" "2581" "26801" "12230" "7670" "53361" "506" "14217" "6682" "919"  "20717" "218" "19904"
"MARCH 2014"     "6278" "2570" "26772" "12326" "7670" "53303" "512" "14206" "6707" "911"  "20723" "235" "19946"
"FEBRUARY 2014"  "6275" "2607" "26804" "12312" "7624" "52994" "511" "14310" "6664" "903"  "20678" "234" "20067"
"JANUARY 2014"   "6216" "2622" "26692" "12287" "7571" "52606" "500" "14209" "6513" "906"  "20383" "246" "19974"
"DECEMBER 2013"  "6072" "2564" "26265" "12101" "7388" "51575" "480" "13999" "6321" "900"  "20027" "254" "19708"
"NOVEMBER 2013"  "6027" "2577" "26177" "12067" "7332" "51428" "468" "14038" "6242" "916"  "20045" "246" "19783"
"OCTOBER 2013"   "6961" "2605" "26075" "12030" "7307" "51238" "464" "14027" "6161" "913"  "20051" "252" "19722"
"SEPTEMBER 2013" "8688" "2626" "26152" "12092" "7297" "51626" "466" "14043" "6165" "931"  "20109" "254" "19879"
"AUGUST 2013"    "8860" "2626" "26204" "12127" "7359" "51859" "469" "14043" "6165" "946"  "20077" "260" "20059"
"JULY 2013"      "8312" "2634" "26016" "12139" "7362" "51863" "472" "14032" "6160" "968"  "20048" "260" "19957"
"JUNE 2013"      "7399" "2609" "25945" "12209" "7351" "51841" "469" "14044" "6152" "962"  "20026" "265" "19939"
"MAY 2013"       "6365" "2613" "25940" "12235" "7425" "51983" "472" "14099" "6156" "979"  "20032" "257" "20019"
"APRIL 2013"     "5826" "2616" "25800" "12267" "7415" "52083" "455" "14081" "6152" "970"  "19989" "244" "19924"
"MARCH 2013"     "5827" "2629" "25699" "12309" "7431" "52171" "445" "14126" "6118" "980"  "19955" "243" "19984"
"FEBRUARY 2013"  "5837" "2618" "25550" "12288" "7450" "52140" "447" "14194" "6091" "976"  "19926" "248" "19949"
"JANUARY 2013"   "5825" "2616" "25504" "12298" "7407" "52222" "461" "14255" "6081" "963"  "19993" "244" "19963"
"DECEMBER 2012"  "5887" "2589" "25365" "12302" "7396" "52021" "473" "14174" "6095" "971"  "19890" "241" "19854"
"NOVEMBER 2012"  "5890" "2604" "25391" "12327" "7436" "52110" "469" "14206" "6151" "985"  "19937" "235" "19909"
"OCTOBER 2012"   "5875" "2623" "25331" "12344" "7427" "52199" "465" "14245" "6137" "992"  "19905" "226" "19934"
"SEPTEMBER 2012" "5891" "2612" "25277" "12314" "7384" "51929" "478" "14247" "6172" "953"  "19985" "222" "19893"
"AUGUST 2012"    "5893" "2627" "25310" "12365" "7366" "51914" "483" "14329" "6186" "938"  "20029" "216" "19870"
"JULY 2012"      "5881" "2593" "25138" "12368" "7340" "51591" "475" "14304" "6141" "916"  "19971" "219" "19827"
"JUNE 2012"      "5904" "2565" "24902" "12344" "7366" "51622" "472" "14311" "6124" "937"  "19998" "218" "19784"
"MAY 2012"       "5968" "2549" "24862" "12369" "7398" "51726" "470" "14310" "6119" "931"  "20008" "213" "19742"
"APRIL 2012"     "5982" "2550" "24681" "12327" "7401" "51663" "473" "14328" "6138" "925"  "19974" "213" "19703"
"MARCH 2012"     "6004" "2569" "24688" "12301" "7407" "51841" "472" "14335" "6169" "936"  "20017" "217" "19816"
"FEBRUARY 2012"  "5980" "2563" "24658" "12314" "7377" "51571" "472" "14293" "6140" "954"  "19934" "222" "19790"
"JANUARY 2012"   "5991" "2559" "24659" "12295" "7350" "51445" "487" "14320" "6092" "961"  "19820" "217" "19775"
"DECEMBER 2011"  "6001" "2569" "24564" "12358" "7372" "51471" "489" "14286" "6032" "958"  "19821" "211" "19822"
"NOVEMBER 2011"  "5994" "2576" "24444" "12450" "7354" "51523" "487" "14268" "5999" "955"  "19835" "214" "19890"
"OCTOBER 2011"   "6027" "2590" "24397" "12428" "7384" "51590" "494" "14330" "6003" "965"  "19830" "202" "19888"
"SEPTEMBER 2011" "6015" "2604" "24315" "12546" "7393" "51494" "492" "14459" "5988" "986"  "19846" "201" "19969"
"AUGUST 2011"    "6002" "2606" "24252" "12488" "7342" "51276" "476" "14473" "5975" "1003" "19817" "204" "19940"
"JULY 2011"      "5997" "2569" "24053" "12423" "7319" "51094" "479" "14450" "5959" "1002" "19696" "205" "19857"
"JUNE 2011"      "5999" "2566" "24081" "12444" "7320" "50927" "460" "14458" "5935" "989"  "19594" "203" "19866"
"MAY 2011"       "5990" "2553" "24042" "12337" "7301" "50833" "458" "14443" "5942" "971"  "19479" "208" "19774"
"APRIL 2011"     "5995" "2521" "24184" "12373" "7342" "50763" "458" "14460" "5914" "976"  "19393" "203" "19758"
"MARCH 2011"     "5992" "2533" "24209" "12418" "7312" "50668" "449" "14453" "5895" "992"  "19372" "211" "19738"
"FEBRUARY 2011"  "5923" "2527" "24091" "12446" "7279" "50449" "443" "14437" "5830" "986"  "19325" "218" "19713"
"JANUARY 2011"   "5935" "2545" "24095" "12415" "7244" "50335" "454" "14467" "5800" "995"  "19293" "217" "19675"
"DECEMBER 2010"  "5920" "2513" "24062" "12382" "7255" "50195" "454" "14496" "5797" "1007" "19262" "213" "19691"
"NOVEMBER 2010"  "5933" "2507" "24081" "12383" "7172" "49872" "459" "14446" "5797" "1008" "19181" "215" "19729"
end

Any ideas/ suggestions on how I can make the second dataset look like that first dataset? My priority is more so getting the county and dates to be repeated for each observation vertically, I know the format for the dates is different for each dataset but that is an easy fix for me compared to this transcription that needs to be done. Any help will be greatly appreciated!

[Clyde Schechter]

* Example generated by -dataex-. To install: ssc install dataex
clear
input str14 Month str4(Adams Asotin) str5(Benton Chelan) str4 Clallam str5 Clark str3 Columbia str5 Cowlitz str4(Douglas Ferry) str5 Franklin str3 Garfield str5 Grant
"FEBRUARY 2019"  "6772" "2896" "30889" "12758" "8549" "58011" "438" "16397" "7533" "949"  "22704" "284" "22341"
"JANUARY 2019"   "6759" "2935" "31019" "12785" "8607" "58183" "444" "16409" "7536" "951"  "22787" "279" "22315"
"DECEMBER 2018"  "6731" "2901" "31071" "12757" "8613" "58339" "440" "16393" "7571" "948"  "22781" "289" "22244"
"NOVEMBER 2018"  "6758" "2893" "31098" "12810" "8633" "58498" "441" "16417" "7515" "938"  "22829" "289" "22271"
"OCTOBER 2018"   "6724" "2914" "31114" "12843" "8629" "58439" "451" "16454" "7500" "940"  "22898" "286" "22335"
"SEPTEMBER 2018" "6741" "2877" "30968" "12839" "8693" "58423" "464" "16447" "7517" "937"  "22995" "282" "22316"
"AUGUST 2018"    "6744" "2882" "31039" "12865" "8634" "58548" "473" "16440" "7546" "939"  "23015" "280" "22299"
"JULY 2018"      "6786" "2866" "31089" "12830" "8652" "58617" "475" "16476" "7543" "936"  "23097" "283" "22214"
"JUNE 2018"      "6825" "2859" "31138" "12833" "8603" "58576" "476" "16447" "7530" "949"  "23022" "279" "22119"
"MAY 2018"       "6839" "2864" "31176" "12872" "8662" "58851" "480" "16445" "7544" "964"  "23017" "284" "22161"
"APRIL 2018"     "6834" "2877" "31151" "12861" "8641" "58846" "482" "16501" "7509" "962"  "22914" "286" "22063"
"MARCH 2018"     "6851" "2893" "31304" "12901" "8711" "59199" "471" "16557" "7520" "957"  "22970" "295" "22099"
"FEBRUARY 2018"  "6850" "2914" "31340" "12962" "8707" "59342" "477" "16552" "7529" "948"  "22944" "305" "22108"
"JANUARY 2018"   "6840" "2895" "31324" "12972" "8733" "59487" "481" "16530" "7582" "952"  "22983" "300" "22050"
"DECEMBER 2017"  "6782" "2868" "31264" "13059" "8715" "59509" "482" "16504" "7578" "946"  "23091" "307" "21989"
"NOVEMBER 2017"  "6761" "2867" "31180" "13092" "8666" "59320" "478" "16456" "7590" "937"  "23084" "295" "21976"
"OCTOBER 2017"   "6792" "2850" "31130" "13141" "8657" "59314" "484" "16389" "7614" "931"  "23130" "297" "22022"
"SEPTEMBER 2017" "6831" "2810" "31117" "13205" "8661" "59342" "481" "16311" "7584" "939"  "23064" "304" "21969"
"AUGUST 2017"    "6812" "2826" "31197" "13218" "8679" "59537" "473" "16355" "7606" "925"  "23073" "301" "21988"
"JULY 2017"      "6827" "2809" "31084" "13219" "8692" "59590" "470" "16291" "7630" "922"  "23022" "297" "22035"
"JUNE 2017"      "6814" "2837" "31111" "13274" "8738" "60000" "463" "16370" "7656" "931"  "23037" "293" "22073"
"MAY 2017"       "6804" "2837" "31061" "13265" "8726" "60118" "469" "16452" "7628" "927"  "22994" "297" "22082"
"APRIL 2017"     "6785" "2831" "31059" "13316" "8734" "60098" "471" "16476" "7615" "922"  "23047" "292" "21981"
"MARCH 2017"     "6793" "2847" "31013" "13343" "8745" "60162" "468" "16454" "7621" "935"  "23012" "297" "22003"
"FEBRUARY 2017"  "6776" "2882" "30974" "13336" "8738" "60194" "470" "16412" "7614" "938"  "22992" "295" "22024"
"JANUARY 2017"   "6788" "2887" "30987" "13319" "8761" "60307" "475" "16431" "7624" "931"  "22988" "296" "22009"
"DECEMBER 2016"  "6786" "2880" "30821" "13280" "8741" "59981" "474" "16346" "7624" "916"  "23002" "300" "21997"
"NOVEMBER 2016"  "6766" "2881" "30711" "13270" "8736" "59767" "472" "16281" "7618" "927"  "22950" "298" "21963"
"OCTOBER 2016"   "6748" "2881" "30598" "13237" "8672" "59722" "485" "16182" "7646" "916"  "22879" "295" "21985"
"SEPTEMBER 2016" "6710" "2854" "30541" "13259" "8653" "59496" "474" "16159" "7638" "912"  "22822" "297" "21886"
"AUGUST 2016"    "6665" "2850" "30448" "13242" "8623" "59221" "467" "16164" "7594" "898"  "22770" "290" "21915"
"JULY 2016"      "6671" "2847" "30230" "13241" "8615" "58932" "462" "16056" "7564" "905"  "22689" "283" "21817"
"JUNE 2016"      "6639" "2836" "30110" "13253" "8623" "58999" "461" "16045" "7569" "903"  "22697" "293" "21805"
"MAY 2016"       "6596" "2802" "29997" "13241" "8560" "58913" "452" "15970" "7569" "898"  "22693" "285" "21741"
"APRIL 2016"     "6547" "2812" "29943" "13327" "8545" "58902" "444" "15928" "7507" "887"  "22651" "289" "21741"
"MARCH 2016"     "6554" "2795" "29841" "13325" "8556" "59021" "467" "15900" "7524" "906"  "22670" "295" "21688"
"FEBRUARY 2016"  "6587" "2773" "29757" "13302" "8533" "58907" "479" "15845" "7512" "897"  "22614" "287" "21702"
"JANUARY 2016"   "6572" "2778" "29658" "13261" "8554" "58836" "481" "15796" "7501" "897"  "22615" "296" "21620"
"DECEMBER 2015"  "6595" "2776" "29612" "13257" "8519" "58630" "488" "15766" "7499" "885"  "22509" "286" "21606"
"NOVEMBER 2015"  "6566" "2762" "29437" "13193" "8499" "58248" "471" "15730" "7470" "858"  "22450" "296" "21577"
"OCTOBER 2015"   "6569" "2757" "29296" "13137" "8451" "57891" "466" "15684" "7450" "873"  "22388" "293" "21554"
"SEPTEMBER 2015" "6592" "2764" "29195" "13093" "8413" "57526" "468" "15645" "7382" "870"  "22389" "283" "21495"
"AUGUST 2015"    "6577" "2757" "28991" "12992" "8324" "57206" "463" "15437" "7342" "867"  "22270" "279" "21318"
"JULY 2015"      "6575" "2736" "28761" "12924" "8282" "56817" "454" "15342" "7320" "900"  "22187" "274" "21185"
"JUNE 2015"      "6596" "2728" "28669" "12911" "8285" "56710" "471" "15213" "7254" "894"  "22112" "268" "21088"
"MAY 2015"       "6542" "2689" "28587" "12831" "8251" "56593" "469" "15068" "7255" "891"  "22106" "272" "20950"
"APRIL 2015"     "6525" "2664" "28456" "12849" "8240" "56492" "478" "14984" "7188" "886"  "22005" "271" "20855"
"MARCH 2015"     "6484" "2680" "28377" "12785" "8197" "56309" "468" "14942" "7139" "893"  "21889" "261" "20770"
"FEBRUARY 2015"  "6453" "2664" "28227" "12760" "8126" "56185" "479" "14837" "7088" "888"  "21829" "261" "20682"
"JANUARY 2015"   "6435" "2641" "27958" "12622" "8037" "55471" "467" "14718" "7016" "879"  "21652" "266" "20534"
"DECEMBER 2014"  "6389" "2584" "27737" "12558" "7935" "54905" "462" "14566" "6974" "862"  "21482" "246" "20419"
"NOVEMBER 2014"  "6371" "2549" "27378" "12402" "7840" "54217" "452" "14372" "6976" "857"  "21358" "252" "20321"
"OCTOBER 2014"   "6388" "2558" "27199" "12407" "7791" "53874" "465" "14354" "6916" "860"  "21261" "259" "20217"
"SEPTEMBER 2014" "6374" "2521" "27059" "12353" "7775" "53488" "470" "14298" "6853" "883"  "21091" "244" "20126"
"AUGUST 2014"    "6410" "2539" "27008" "12380" "7723" "53563" "472" "14263" "6797" "873"  "20974" "244" "20092"
"JULY 2014"      "6381" "2534" "26863" "12275" "7704" "53543" "478" "14129" "6786" "888"  "20904" "247" "20012"
"JUNE 2014"      "6350" "2555" "26860" "12288" "7708" "53617" "480" "14147" "6737" "910"  "20863" "242" "19989"
"MAY 2014"       "6320" "2573" "26802" "12270" "7693" "53435" "488" "14220" "6733" "905"  "20771" "235" "19988"
"APRIL 2014"     "6331" "2581" "26801" "12230" "7670" "53361" "506" "14217" "6682" "919"  "20717" "218" "19904"
"MARCH 2014"     "6278" "2570" "26772" "12326" "7670" "53303" "512" "14206" "6707" "911"  "20723" "235" "19946"
"FEBRUARY 2014"  "6275" "2607" "26804" "12312" "7624" "52994" "511" "14310" "6664" "903"  "20678" "234" "20067"
"JANUARY 2014"   "6216" "2622" "26692" "12287" "7571" "52606" "500" "14209" "6513" "906"  "20383" "246" "19974"
"DECEMBER 2013"  "6072" "2564" "26265" "12101" "7388" "51575" "480" "13999" "6321" "900"  "20027" "254" "19708"
"NOVEMBER 2013"  "6027" "2577" "26177" "12067" "7332" "51428" "468" "14038" "6242" "916"  "20045" "246" "19783"
"OCTOBER 2013"   "6961" "2605" "26075" "12030" "7307" "51238" "464" "14027" "6161" "913"  "20051" "252" "19722"
"SEPTEMBER 2013" "8688" "2626" "26152" "12092" "7297" "51626" "466" "14043" "6165" "931"  "20109" "254" "19879"
"AUGUST 2013"    "8860" "2626" "26204" "12127" "7359" "51859" "469" "14043" "6165" "946"  "20077" "260" "20059"
"JULY 2013"      "8312" "2634" "26016" "12139" "7362" "51863" "472" "14032" "6160" "968"  "20048" "260" "19957"
"JUNE 2013"      "7399" "2609" "25945" "12209" "7351" "51841" "469" "14044" "6152" "962"  "20026" "265" "19939"
"MAY 2013"       "6365" "2613" "25940" "12235" "7425" "51983" "472" "14099" "6156" "979"  "20032" "257" "20019"
"APRIL 2013"     "5826" "2616" "25800" "12267" "7415" "52083" "455" "14081" "6152" "970"  "19989" "244" "19924"
"MARCH 2013"     "5827" "2629" "25699" "12309" "7431" "52171" "445" "14126" "6118" "980"  "19955" "243" "19984"
"FEBRUARY 2013"  "5837" "2618" "25550" "12288" "7450" "52140" "447" "14194" "6091" "976"  "19926" "248" "19949"
"JANUARY 2013"   "5825" "2616" "25504" "12298" "7407" "52222" "461" "14255" "6081" "963"  "19993" "244" "19963"
"DECEMBER 2012"  "5887" "2589" "25365" "12302" "7396" "52021" "473" "14174" "6095" "971"  "19890" "241" "19854"
"NOVEMBER 2012"  "5890" "2604" "25391" "12327" "7436" "52110" "469" "14206" "6151" "985"  "19937" "235" "19909"
"OCTOBER 2012"   "5875" "2623" "25331" "12344" "7427" "52199" "465" "14245" "6137" "992"  "19905" "226" "19934"
"SEPTEMBER 2012" "5891" "2612" "25277" "12314" "7384" "51929" "478" "14247" "6172" "953"  "19985" "222" "19893"
"AUGUST 2012"    "5893" "2627" "25310" "12365" "7366" "51914" "483" "14329" "6186" "938"  "20029" "216" "19870"
"JULY 2012"      "5881" "2593" "25138" "12368" "7340" "51591" "475" "14304" "6141" "916"  "19971" "219" "19827"
"JUNE 2012"      "5904" "2565" "24902" "12344" "7366" "51622" "472" "14311" "6124" "937"  "19998" "218" "19784"
"MAY 2012"       "5968" "2549" "24862" "12369" "7398" "51726" "470" "14310" "6119" "931"  "20008" "213" "19742"
"APRIL 2012"     "5982" "2550" "24681" "12327" "7401" "51663" "473" "14328" "6138" "925"  "19974" "213" "19703"
"MARCH 2012"     "6004" "2569" "24688" "12301" "7407" "51841" "472" "14335" "6169" "936"  "20017" "217" "19816"
"FEBRUARY 2012"  "5980" "2563" "24658" "12314" "7377" "51571" "472" "14293" "6140" "954"  "19934" "222" "19790"
"JANUARY 2012"   "5991" "2559" "24659" "12295" "7350" "51445" "487" "14320" "6092" "961"  "19820" "217" "19775"
"DECEMBER 2011"  "6001" "2569" "24564" "12358" "7372" "51471" "489" "14286" "6032" "958"  "19821" "211" "19822"
"NOVEMBER 2011"  "5994" "2576" "24444" "12450" "7354" "51523" "487" "14268" "5999" "955"  "19835" "214" "19890"
"OCTOBER 2011"   "6027" "2590" "24397" "12428" "7384" "51590" "494" "14330" "6003" "965"  "19830" "202" "19888"
"SEPTEMBER 2011" "6015" "2604" "24315" "12546" "7393" "51494" "492" "14459" "5988" "986"  "19846" "201" "19969"
"AUGUST 2011"    "6002" "2606" "24252" "12488" "7342" "51276" "476" "14473" "5975" "1003" "19817" "204" "19940"
"JULY 2011"      "5997" "2569" "24053" "12423" "7319" "51094" "479" "14450" "5959" "1002" "19696" "205" "19857"
"JUNE 2011"      "5999" "2566" "24081" "12444" "7320" "50927" "460" "14458" "5935" "989"  "19594" "203" "19866"
"MAY 2011"       "5990" "2553" "24042" "12337" "7301" "50833" "458" "14443" "5942" "971"  "19479" "208" "19774"
"APRIL 2011"     "5995" "2521" "24184" "12373" "7342" "50763" "458" "14460" "5914" "976"  "19393" "203" "19758"
"MARCH 2011"     "5992" "2533" "24209" "12418" "7312" "50668" "449" "14453" "5895" "992"  "19372" "211" "19738"
"FEBRUARY 2011"  "5923" "2527" "24091" "12446" "7279" "50449" "443" "14437" "5830" "986"  "19325" "218" "19713"
"JANUARY 2011"   "5935" "2545" "24095" "12415" "7244" "50335" "454" "14467" "5800" "995"  "19293" "217" "19675"
"DECEMBER 2010"  "5920" "2513" "24062" "12382" "7255" "50195" "454" "14496" "5797" "1007" "19262" "213" "19691"
"NOVEMBER 2010"  "5933" "2507" "24081" "12383" "7172" "49872" "459" "14446" "5797" "1008" "19181" "215" "19729"
end

//  CREATE A REAL STATA INTERNAL FORMAT MONTHLY DATE
gen mdate = monthly(Month, "MY")
assert missing(mdate) == missing(Month)
format mdate %tm

destring Adams-Grant, replace

rename (Adams-Grant) enroll=

reshape long enroll, i(mdate) j(county_name) string
rename enroll medicaid_enroll

gen int year = year(dofm(mdate))
gen int month = month(dofm(mdate))

I have created the year and month variables at the end, though probably they won't prove as useful as the mdate variable. It depends on what you're going to be doing.

Note: If any of the original values of the variables Adams-Grant contains non-numeric material (e.g. N/A, or just some typo that isn't a number), the -destring- command will give you a message saying that it couldn't convert that variable to numeric. The code will not break at that point, but then the -reshape- command will break and tell you that there is a type mismatch among the enroll variables. So if you get such a message, you will have to go back to find and fix the inappropriate values in those variables.