![\"\"](\"http:\/\/web.education.wisc.edu\/nwhillman\/wp-content\/uploads\/sites\/16\/2019\/05\/stata_counties.png\")
<\/a><\/p>\nThis copies each file from 2000 through 2018, saves and cleans it to your local machine, and then stacks them all together in a panel format. I haven’t fully spot-checked, so please let me know if you see bugs.<\/p>\n
Disclaimer: I have never figured out the whole Git Hub thing. I suspect if you’re reading this page there’s a good chance you haven’t either. So please don’t proselytize, just use this as a resource. WordPress doesn’t allow uploading .do files, but here’s what’s you could do:<\/p>\n
\/\/ set local directory
\ncd C:\\Users\\BLS_LAUS<\/p>\n
\/\/ copy data (2000 to 2018) from BLS website
\nlocal years 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18
\nforeach y of local years {
\nimport excel https:\/\/www.bls.gov\/lau\/laucnty`y’.xlsx
\nkeep if substr(A, 1, 2) == “CN”
\nrename A laus_code
\nrename B state_fips
\nrename C county_fips_3
\nrename D county_name
\nrename E year
\ndrop F
\nrename G labor_force
\nrename H employed
\nrename I unemployed
\nrename J unemp_rate
\nreplace labor_force = “” if labor_force==”N.A.”
\nreplace employed = “” if employed == “N.A.”
\nreplace unemployed = “” if unemployed==”N.A.”
\nreplace unemp_rate = “” if unemp_rate == “N.A.”
\ndestring year-unemp_rate, replace
\ngenerate str county_fips = state_fips + county_fips_3
\nsave county_20`y’.dta, replace
\nclear
\n}<\/p>\n
\/\/ append each year starting with 2000
\nuse county_2000.dta
\nforvalues y=2001\/2018 {
\nappend using county_`y’.dta
\n}
\nsave county_panel_2000_2018.dta, replace<\/p>\n
\/\/ table of total labor force, employed, and unemployed
\ntable year, c(sum labor_force sum employed sum unemployed) f(%20.0fc)<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
If you have ever looked for a way to get county-level unemployment rates for each county over time, there are probably a few ways to go about that task. Below is one way to do it in Stata. This copies each file from 2000 through 2018, saves and cleans it to your local machine, and […]<\/p>\n","protected":false},"author":22,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1],"tags":[],"class_list":["post-544","post","type-post","status-publish","format-standard","hentry","category-community-college-research"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/posts\/544","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/comments?post=544"}],"version-history":[{"count":0,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/posts\/544\/revisions"}],"wp:attachment":[{"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/media?parent=544"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/categories?post=544"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/tags?post=544"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}