// DATASET: Employment rates by sex, age and nationality (%) [lfsa_ergan]
// LAST UPDATE: 27.11.14 13:37:54
// EXTRACTION DATE: 13.12.14 03:32:55
// SOURCE OF DATA: Eurostat
insheet using "lfsa_ergan_1_Data.csv", clear names
drop sex age citizen
// 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
replace country_str = "EU27" if geo == "European Union (27 countries)"
replace country_str = "EU28" if geo == "European Union (28 countries)"
replace country_str = "EU15" if geo == "European Union (15 countries)"
// Fix labor force participation rate
replace value = "" if value == ":" // Fix missing data indicator
destring value, replace // Convert to numeric
twoway (line value time if country_str == "NL") ///
(line value time if country_str == "UK") ///
(line value time if country_str == "EU15") ///
(line value time if country_str == "ES") ///
, legend(label(1 "NL") ///
label(2 "UK") ///
label(3 "EU-15") ///
label(4 "ES") ///
pos(5) ring(0)) ///
xtitle("") ytitle("Female labor force participation rate") ///
xlabel(1995(5)2010 2013) ///
note(" " "{it: Source:} Eurostat, lfsa_ergan, date of extraction: 2014-12-13", span)
