import delimited une_rt_a_1_Data.csv, clear
/*
DATASET: Unemployment by sex and age - annual average [une_rt_a]
LAST UPDATE: 14.06.17 13:10:19
EXTRACTION DATE: 18.06.17 11:35:33
SOURCE OF DATA: Eurostat
*/
drop sex age unit flagandfootnotes
// Generate country variable
kountryadd "Germany (until 1990 former territory of the FRG)" to "Germany" add
kountry geo, from(other) stuck marker
ren _ISO3N_ country
kountry country, from(iso3n) to(iso2c)
ren _ISO2C_ country_str
replace country_str = "UK" if country_str == "GB"
list country_str geo
// Fix unemployment rate
replace value = "" if value == ":" // Fix missing data indicator
destring value, replace // Convert to numeric
// Plot
twoway (scatteri 12 2008 12 2012, recast(area) bcolor(gs14)) ///
(line value time if country_str == "UK") ///
(line value time if country_str == "DE") ///
(line value time if country_str == "US") ///
, legend(order(2 "UK" 3 "Germany" 4 "US") ///
pos(7) ring(0)) ///
xtitle("") ytitle("Male unemployment rate, 25-74 y.") xtick(1983(1)2016) ///
xlabel(1985(5)2015) ///
note(" " "{it: Source:} Eurostat, une_rt_a, date of extraction: 2017-06-18", span)
