I currently have data that looks like this
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input int year str36 name str10 allages str7(v6 v7 v8 v9 v10 v11 v12) 2012 "ENGLAND" "27,160,281" "339,662" "333,659" "329,489" "325,391" "328,239" "317,666" "311,930" 2012 "NORTH EAST" "1,329,159" "14,909" "14,996" "14,791" "14,436" "14,838" "14,231" "14,456" 2012 "County Durham" "262,196" "2,755" "2,913" "2,877" "2,730" "2,879" "2,727" "2,733" 2012 "Darlington" "54,102" "661" "629" "651" "632" "692" "620" "657" 2012 "Hartlepool" "47,396" "557" "559" "575" "565" "552" "555" "580" 2012 "Middlesbrough" "70,737" "983" "1,039" "925" "919" "902" "907" "930" 2012 "Northumberland" "162,019" "1,507" "1,520" "1,569" "1,562" "1,650" "1,508" "1,626" 2012 "Redcar and Cleveland" "69,359" "755" "798" "750" "682" "714" "724" "760" 2012 "Stockton-on-Tees" "97,888" "1,245" "1,223" "1,225" "1,229" "1,256" "1,202" "1,165" 2012 "Tyne and Wear (Met County)" "565,462" "6,446" "6,315" "6,219" "6,117" "6,193" "5,988" "6,005" 2012 "Gateshead" "102,346" "1,134" "1,206" "1,117" "1,222" "1,087" "1,142" "1,150" 2012 "Newcastle upon Tyne" "140,686" "1,657" "1,695" "1,663" "1,568" "1,605" "1,475" "1,418" 2012 "North Tyneside" "104,241" "1,172" "1,149" "1,144" "1,077" "1,151" "1,072" "1,162" 2012 "South Tyneside" "76,666" "846" "790" "807" "784" "823" "805" "791" 2012 "Sunderland" "141,523" "1,637" "1,475" "1,488" "1,466" "1,527" "1,494" "1,484" 2012 "NORTH WEST" "3,600,688" "43,919" "43,373" "42,508" "42,035" "42,661" "41,422" "40,801" 2012 "Blackburn with Darwen" "74,086" "1,170" "1,046" "1,094" "1,165" "1,117" "1,123" "1,076" 2012 "Blackpool" "72,184" "932" "830" "810" "795" "783" "814" "754" 2012 "Cheshire East" "189,804" "1,991" "2,091" "1,858" "1,976" "1,983" "2,023" "2,017" 2012 "Cheshire West and Chester" "169,379" "1,814" "1,795" "1,800" "1,724" "1,850" "1,772" "1,742" 2012 "Halton" "64,418" "762" "807" "910" "810" "825" "782" "825" 2012 "Warrington" "102,720" "1,195" "1,294" "1,166" "1,230" "1,252" "1,219" "1,137" 2012 "Cumbria" "253,410" "2,527" "2,524" "2,453" "2,335" "2,515" "2,514" "2,502" 2012 "Allerdale" "48,927" "480" "523" "510" "430" "502" "490" "443" 2012 "Barrow-in-Furness" "34,623" "386" "366" "330" "362" "369" "390" "351" 2012 "Carlisle" "55,227" "656" "627" "586" "575" "597" "578" "584" 2012 "Copeland" "34,998" "373" "353" "366" "321" "377" "338" "373" 2012 "Eden" "26,559" "187" "222" "237" "221" "245" "231" "269" 2012 "South Lakeland" "53,076" "445" "433" "424" "426" "425" "487" "482" 2012 "Greater Manchester (Met County)" "1,365,239" "18,691" "18,381" "17,932" "17,463" "17,750" "17,134" "16,866" 2012 "Bolton" "141,085" "2,003" "1,957" "1,920" "1,838" "1,784" "1,790" "1,743" 2012 "Bury" "95,104" "1,244" "1,277" "1,167" "1,124" "1,291" "1,196" "1,121" 2012 "Manchester" "253,242" "4,081" "3,705" "3,625" "3,388" "3,484" "3,327" "3,293" 2012 "Oldham" "115,063" "1,648" "1,642" "1,650" "1,634" "1,645" "1,632" "1,598" 2012 "Rochdale" "108,158" "1,461" "1,484" "1,429" "1,480" "1,416" "1,413" "1,374" 2012 "Salford" "118,530" "1,709" "1,750" "1,579" "1,502" "1,506" "1,482" "1,406" 2012 "Stockport" "145,061" "1,723" "1,710" "1,688" "1,702" "1,746" "1,660" "1,613" 2012 "Tameside" "112,121" "1,518" "1,485" "1,498" "1,390" "1,440" "1,288" "1,361" 2012 "Trafford" "116,556" "1,382" "1,472" "1,469" "1,495" "1,541" "1,503" "1,471" 2012 "Wigan" "160,319" "1,922" "1,899" "1,907" "1,910" "1,897" "1,843" "1,886" 2012 "Lancashire" "597,191" "6,529" "6,719" "6,738" "6,762" "6,840" "6,568" "6,629" 2012 "Burnley" "44,278" "602" "551" "597" "575" "614" "557" "559" 2012 "Chorley" "54,398" "612" "649" "634" "627" "641" "617" "598" 2012 "Fylde" "39,048" "294" "414" "370" "353" "381" "342" "368" 2012 "Hyndburn" "40,514" "539" "517" "518" "532" "553" "533" "492" 2012 "Lancaster" "71,694" "775" "779" "688" "649" "743" "636" "637" 2012 "Pendle" "45,407" "616" "632" "623" "664" "591" "556" "594" 2012 "Preston" "69,770" "876" "888" "952" "928" "856" "818" "898" 2012 "Ribble Valley" "29,311" "225" "246" "288" "295" "279" "320" "320" 2012 "Rossendale" "34,765" "428" "435" "427" "461" "432" "412" "421" 2012 "South Ribble" "55,599" "568" "626" "602" "632" "635" "624" "624" 2012 "West Lancashire" "56,932" "544" "534" "573" "573" "614" "599" "575" 2012 "Wyre" "55,475" "450" "448" "466" "473" "501" "554" "543" 2012 "Merseyside (Met County)" "712,257" "8,308" "7,886" "7,747" "7,775" "7,746" "7,473" "7,253" 2012 "Knowsley" "76,558" "922" "954" "867" "897" "896" "846" "897" 2012 "Liverpool" "237,315" "3,009" "2,641" "2,536" "2,575" "2,556" "2,441" "2,261" 2012 "Sefton" "142,602" "1,386" "1,439" "1,441" "1,402" "1,415" "1,447" "1,323" 2012 "St. Helens" "89,614" "1,092" "1,021" "1,070" "1,048" "995" "968" "965" 2012 "Wirral" "166,168" "1,899" "1,831" "1,833" "1,853" "1,884" "1,771" "1,807" 2012 "YORKSHIRE AND THE HUMBER" "2,698,787" "33,314" "32,361" "32,652" "32,490" "32,220" "31,533" "31,222" 2012 "East Riding of Yorkshire" "171,545" "1,463" "1,556" "1,649" "1,646" "1,721" "1,632" "1,646" 2012 "Kingston upon Hull, City of" "128,059" "1,883" "1,734" "1,713" "1,660" "1,653" "1,531" "1,549" 2012 "North East Lincolnshire" "81,428" "1,054" "960" "1,048" "1,018" "934" "927" "915" 2012 "North Lincolnshire" "85,233" "944" "1,019" "975" "1,026" "1,044" "991" "996" 2012 "York" "102,323" "1,051" "1,031" "1,071" "1,046" "1,041" "1,075" "1,008" 2012 "North Yorkshire" "305,771" "3,049" "3,023" "3,048" "3,023" "3,111" "3,111" "3,081" 2012 "Craven" "28,778" "267" "240" "255" "248" "240" "239" "289" 2012 "Hambleton" "45,362" "452" "423" "437" "404" "476" "443" "445" 2012 "Harrogate" "81,387" "797" "843" "848" "863" "869" "885" "888" 2012 "Richmondshire" "24,683" "302" "310" "258" "285" "300" "270" "237" 2012 "Ryedale" "26,531" "201" "241" "249" "227" "224" "229" "269" 2012 "Scarborough" "56,095" "566" "513" "525" "507" "535" "535" "489" 2012 "Selby" "42,935" "464" "453" "476" "489" "467" "510" "464" 2012 "South Yorkshire (Met County)" "685,278" "8,316" "8,009" "8,237" "8,259" "8,153" "7,919" "7,814" 2012 "Barnsley" "118,749" "1,480" "1,374" "1,405" "1,360" "1,358" "1,285" "1,343" 2012 "Doncaster" "153,268" "1,832" "1,872" "1,906" "1,936" "1,922" "1,858" "1,815" 2012 "Rotherham" "131,582" "1,548" "1,522" "1,567" "1,584" "1,573" "1,482" "1,535" 2012 "Sheffield" "281,679" "3,456" "3,241" "3,359" "3,379" "3,300" "3,294" "3,121" 2012 "West Yorkshire (Met County)" "1,139,150" "15,554" "15,029" "14,911" "14,812" "14,563" "14,347" "14,213" 2012 "Bradford" "266,199" "4,140" "3,994" "4,036" "4,066" "3,948" "3,999" "4,041" 2012 "Calderdale" "104,847" "1,290" "1,259" "1,304" "1,292" "1,289" "1,315" "1,318" 2012 "Kirklees" "215,283" "2,942" "2,926" "2,746" "2,750" "2,865" "2,750" "2,689" 2012 "Leeds" "385,912" "5,107" "4,896" "4,898" "4,765" "4,593" "4,394" "4,310" 2012 "Wakefield" "166,909" "2,075" "1,954" "1,927" "1,939" "1,868" "1,889" "1,855" 2012 "EAST MIDLANDS" "2,315,807" "27,265" "27,133" "26,777" "26,604" "27,128" "26,321" "26,007" 2012 "Derby" "126,696" "1,922" "1,798" "1,715" "1,705" "1,799" "1,636" "1,530" 2012 "Leicester" "167,952" "2,621" "2,504" "2,390" "2,441" "2,387" "2,229" "2,149" 2012 "Nottingham" "152,800" "2,140" "1,927" "1,950" "1,903" "1,923" "1,866" "1,772" 2012 "Rutland" "18,355" "152" "171" "191" "172" "178" "217" "189" 2012 "Derbyshire" "393,309" "4,096" "4,154" "4,081" "4,033" "4,237" "4,065" "4,221" 2012 "Amber Valley" "62,481" "607" "650" "628" "620" "656" "674" "636" 2012 "Bolsover" "38,804" "444" "469" "364" "415" "436" "420" "475" 2012 "Chesterfield" "52,938" "598" "577" "568" "545" "614" "554" "535" 2012 "Derbyshire Dales" "36,210" "312" "285" "303" "307" "353" "301" "343" 2012 "Erewash" "57,611" "663" "646" "666" "646" "637" "577" "619" 2012 "High Peak" "46,261" "488" "502" "472" "484" "460" "515" "499" 2012 "North East Derbyshire" "50,672" "465" "471" "491" "459" "504" "481" "519" 2012 "South Derbyshire" "48,332" "519" "554" "589" "557" "577" "543" "595" 2012 "Leicestershire" "331,933" "3,485" "3,637" "3,671" "3,559" "3,626" "3,623" "3,584" 2012 "Blaby" "48,125" "487" "544" "548" "558" "561" "571" "547" end
Thanks in advance!
0 Response to Dividing lots of variables by one column.
Post a Comment